-
All replies
-
Helpful answers
-
Sep 17, 2016 3:52 PM in response to Frisiby SGIII,If I understand correctly one way you could do this is like this:
The formula in F3, copied down the column, is:
=IF(B3,F3+G2,0)
On a German system I believe the equivalent is:
=WENN(B3;F3+G2;0)
This will put zeros where you currently have FALSE.
Then apply a custom format to column F that contains a rule to hide the zeroes, like this:
-
Sep 17, 2016 8:29 PM in response to Frisiby Frisi,Hi SGlll,
great, thank you, that almost did it.
But how do I get G6 to accumulate with G4, when G5 in between is zero.
Best
Tina
-
-


