ExcelBanter - YTD Totals

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - YTD Totals (https://www.excelbanter.com/excel-discussion-misc-queries/3773-ytd-totals.html)

Judy

YTD Totals

I have a spreadsheet table that lists each month and the totals at the end
for the past 5 years. Is there a simple formula to put in to give me the YTD
increase or decrease. The formulas I have tried give me incorrect totals.

Lady Layla

What formulas are you trying?

It is a simple Current YTD - whatever Prior YTD you are comparing it to =
increase or decrease

"Judy" wrote in message
...
: I have a spreadsheet table that lists each month and the totals at the end
: for the past 5 years. Is there a simple formula to put in to give me the YTD
: increase or decrease. The formulas I have tried give me incorrect totals.

All times are GMT +1. The time now is 03:17 AM.