krispatterson
Board Regular
- Joined
- Apr 28, 2017
- Messages
- 51
Hi all
data as follows:
<tbody>
</tbody>
I need a formula in D1 that:
> Looks at Column C
- if "N", puts the figure from Column A as a - (negative).
- if "Y", puts the figure from Column B as a + (positive).
I then want it to run a cumulative running total, so that the results in Column D are:
<tbody>
</tbody>
There will also be instances where Column C is blank - I need the formula to ignore those instances.
Hope that makes sense - I think I might need a SUMIFs, but can't figure out how to get it working!!
Thanks in advance
data as follows:
A | B | C | D | |
1 | 10 | 5 | N | |
2 | 5 | 1 | N | |
3 | 6 | 12 | Y | |
4 | 1 | 3 | N | |
5 | 14 | 13 | Y |
<tbody>
</tbody>
I need a formula in D1 that:
> Looks at Column C
- if "N", puts the figure from Column A as a - (negative).
- if "Y", puts the figure from Column B as a + (positive).
I then want it to run a cumulative running total, so that the results in Column D are:
D | |
1 | -10 |
2 | -15 |
3 | -3 |
4 | -4 |
5 | 10 |
<tbody>
</tbody>
There will also be instances where Column C is blank - I need the formula to ignore those instances.
Hope that makes sense - I think I might need a SUMIFs, but can't figure out how to get it working!!
Thanks in advance
Last edited: