Summing multiple columns if multiple columns are greater than zero

[CCarolyn]

Hi, I would appreciate assistance creating the correct formula to :
SUM columns B, D and F ONLY if there are figures greater than zero in columns C, E and G
(The result to find the YTD Budget in column H)
I have tried numerous with not much luck!
Thanks


[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jan Budget[/TD]
[TD]Jan Actual[/TD]
[TD]Feb Budget[/TD]
[TD]Feb Actual[/TD]
[TD]Mar Budget[/TD]
[TD]Mar Actual[/TD]
[TD]Budget YTD[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]500[/TD]
[TD]550[/TD]
[TD]100[/TD]
[TD]102[/TD]
[TD]120[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]500[/TD]
[TD]500[/TD]
[TD]100[/TD]
[TD]101[/TD]
[TD]120[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]500[/TD]
[TD]520[/TD]
[TD]100[/TD]
[TD]110[/TD]
[TD]120[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<attachment></attachment>

 

[snjpverma]

try this

=B3*(C3>0)+D3*(E3>0)+F3*(G3>0)

 

[CCarolyn]

thankyou very much