LarsAustin
New Member
- Joined
- Feb 27, 2016
- Messages
- 16
Hello,
I am trying to find an efficient formula that will add the values in B4:F4 (yellow cells) and then subtract it from the value in A1 and put it in cell A2. But then I want the same for values in G4:J4 (gold cells) and then subtract it from the value in G1 and put in cell G2. And so on the next.
The pattern is that it will add the values in row 4 but only up to a point where the next adjacent cell in Row 1 is not equal to zero.
I hope clearly explain what I want to achieve.
Thank you.
<tbody>
</tbody>
I am trying to find an efficient formula that will add the values in B4:F4 (yellow cells) and then subtract it from the value in A1 and put it in cell A2. But then I want the same for values in G4:J4 (gold cells) and then subtract it from the value in G1 and put in cell G2. And so on the next.
The pattern is that it will add the values in row 4 but only up to a point where the next adjacent cell in Row 1 is not equal to zero.
I hope clearly explain what I want to achieve.
Thank you.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |
1 | 960 | 360 | 360 | 360 | |||||||||||||||||
2 | 870 | 330 | 240 | 330 | |||||||||||||||||
3 | |||||||||||||||||||||
4 | 30 | 0 | 30 | 0 | 30 | 0 | 0 | 0 | 30 | 0 | 0 | 30 | 30 | 30 | 0 | 0 | 30 | 0 | 0 | 30 | 0 |
<tbody>
</tbody>