Sum multiple If statements?

[Dcata]

Please help!

Is there a formula that I can put into cell E5 that calculates... for cells E2:E4 if E=1 and D="" then B*C, and then returns the sum in E5?

Cheers!

	A	B	C	D	E	F
1	person	Cost	%	mon	tue	wed
2	aa	20000	10%	1	1	1
3	bb	30000	20%		1	1
4	cc	10000	30%			1
5		Cost			6000	3000

<tbody>
</tbody>

 

[Scott T]

Does this do what you want?

Excel 2010
	A	B	C	D	E	F
1	person	Cost	%	mon	tue	wed
2	aa	20000	10%	1	1	1
3	bb	30000	20%		1	1
4	cc	10000	30%			1
5		Cost			6000	3000
Sheet5

Cell Formulas
Range	Formula
E5	=SUMPRODUCT(--(E2:E4=1),--(D2:D4=""),$B$2:$B$4*$C$2:$C$4)
F5	=SUMPRODUCT(--(F2:F4=1),--(E2:E4=""),$B$2:$B$4*$C$2:$C$4)

 

[Joe4]

Welcome to the Board!

This would do that:

=SUMPRODUCT(--(E2:E4=1),--(D2:D4=""),B2:B4*C2:C4)

EDIT: Too slow, looks like Scott beat me to the punch!

 

[Dcata]

that does it! Cheers