IF OR SUMIF OR SUMTHING ELSE

[Dunc]

Sorry about the subject title for all you searching but I couldnt summarise it. (in fact im having difficulty explaining it)

I would like the formula

IF the text of a cell in column D = "STRING" THEN its corresponding cell in column C should be added to the cell where the formula is.

With Kind Regards


Duncan
This message was edited by Dunc on 2002-10-25 13:01

 

[Andrew Poulsom]

That's:

=SUMIF(E5:E8,E5,C5:C8)