| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Range & Difference | Excel Worksheet Functions | |||
| Count difference based on Range | Excel Worksheet Functions | |||
| Sumproduct against worksheet vs named range- any speed difference? | Excel Worksheet Functions | |||
| Greatest difference between a consecutive range of dates | Excel Discussion (Misc queries) | |||
| Labelling a row so it can be used as an offset for sum, difference or range | Excel Discussion (Misc queries) | |||
Hybrid Mode
