sum the difference in a range
 

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).

sum the difference in a range
 

"carla" wrote in message
...
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).

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.

sum the difference in a range
 

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!

"Stephen" wrote:

"carla" wrote in message
...
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).

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.