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!

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]person[/TD]
[TD]Cost[/TD]
[TD]%[/TD]
[TD]mon[/TD]
[TD]tue[/TD]
[TD]wed[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]aa[/TD]
[TD]20000[/TD]
[TD]10%[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]bb[/TD]
[TD]30000[/TD]
[TD]20%[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]cc[/TD]
[TD]10000[/TD]
[TD]30%[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]Cost[/TD]
[TD][/TD]
[TD][/TD]
[TD]6000[/TD]
[TD]3000[/TD]
[/TR]
</tbody>[/TABLE]

 

[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