Cumulative total relating to daily updated data

[alancyoung]

Please help! I am trying to get a formula to keep a running cumulative total at the end of a row, but only if the row below is populated. See example below


A B C D E F
Row1 100 0 200 100 100 =300
Row2 100 200 100 =400

D2, E2 and F2 do not have data yet, so don't want to SUM E1 and F1 until populated.

I've tried SUMIFS formula, using >0, but when E2 is a 0 value due to formula, it won't SUM, and there are times when it is a zero value, I do want it to SUM!!!!

Please Help!!!!!

 

[Robert Mika]

Change

=IF(H7=0," ",H7)
(space)

to
=IF(H7=0,"",H7)
(empty)

and use

=SUMPRODUCT(--(LEN($B$3:$M$3)>0),$B$2:$M$2)

 

[alancyoung]

Change

=IF(H7=0," ",H7)
(space)

to
=IF(H7=0,"",H7)
(empty)

and use

=SUMPRODUCT(--(LEN($B$3:$M$3)>0),$B$2:$M$2)

Thanks for that. Much appreciated.

 

[Robert Mika]

You are welcome