sum the difference in a range

C

carla

I'm still learning excel... can you help me create a formula that calculates
the difference (YTD gain/loss) for a range of amounts (monthly balances).
 
S

Stephen

carla said:
I'm still learning excel... can you help me create a formula that
calculates
the difference (YTD gain/loss) for a range of amounts (monthly balances).
Click to expand...

Suppose your opening balance is in A1 and your month end balances are in
A2:A13.
In B2, put this formula:
=A2-$A$1
Copy this formula down into B3:B13.
That will give you the YTD gain/loss.
 
C

carla

I need to have only one column for a YTD gain/loss amount. How would I go
about setting that up? If A1 is my opening balance, then the monthly
balances are in A2:13, I would like one YTD gain/loss value in cell A14.
What do you suggest? Thank you!
 
Top