SUMIF Formula....

[gjs1985]

Hi,

Please see below an example of what I am trying to solve:

I'm trying to return the sum of all numbers in columns C, D & E but only where column B is "Ongoing". As you can see, the answer should be 2165 but using the following formula only gives the result of 560:

=SUMIF(B:B, "Ongoing", C:E)

For some reason it is only summing up the figures in column C and not looking to columns D or E.

Any help would be greatly appreciated.

 

[Dave Patton]

Check Excel's help for Sumif.

Excel 2010
	B	C	D	E
1		60	160	160
2	Total
3	Ongoing	10
4	Ongoing	20	20	20
5	Ongoing	30	30	30
6	XX	100	100	100
7
1d

Cell Formulas
Range	Formula
C1	=SUMIF(B3:B5,"Ongoing",C3:C5)
D1	=SUMPRODUCT((B3:B10="ongoing")*(C3:E10))
E1	=SUMIF(B3:B10,"Ongoing",C3:C10)+SUMIF(B3:B10,"Ongoing",D3:D10)+SUMIF(B3:B10,"Ongoing",E3:E10)