Gavin has attended:
Excel Introduction course
Excel Intermediate course
CUMULATIVE PROFIT/LOSS
I am putting together a financial plan and need the formula to calculate the cumulative profit/loss line which is below the balance (net profit/loss)
b28 is the same as b26
but c28 is b26 + c26
d28 is b26 + c26 + d28
and so on
How do I do this?
RE: CUMULATIVE PROFIT/LOSS
Hi Gavin, thanks for your query. Put this into B28 and autofill across:
=SUM($B$26:B26)
Hope this helps,
Anthony