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
<tbody>
</tbody> <attachment></attachment>
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>