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

A	B	C	D	E	F	G	H
	Jan Budget	Jan Actual	Feb Budget	Feb Actual	Mar Budget	Mar Actual	Budget YTD
1	500	550	100	102	120
2	500	500	100	101	120
3	500	520	100	110	120

<tbody>
</tbody>

<attachment></attachment>

 

[snjpverma]

try this

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

 

[CCarolyn]

thankyou very much