Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automated Year-to-Date Comparisons
I have a spreadsheet that I enter the current month's data
into each month. This new data is entered alongside data entered in the previous months of the current fiscal year. Let's say, for argument's sake, that I have just entered the data for month three of the current fiscal year. I want Excel to sum the data for the same three month period during the previous fiscal year ... providing a year-to-date comparison. And, when I enter the data for month four of the current fiscal year, I want Excel to sum the data for the same four month period during the previous fiscal year ... but I want Excel to make this transition (from three to four months) automatically. In other words, I don't want to rewrite the formula every month. Is this possible? If so, how's it done? Thanks in advance to anyone who can help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automated Year-to-Date Comparisons
Michael,
As I do not know the layout of your data this will be a little lon winded. Assuming the last years figures are in cells b2:b13 and this year figures are in cells c2:c13 then the formula =IF(C20,SUM($B$2:B2),"") entered in cell d2 and copied down for th whole of the list will sum the values in column b starting from b2 t the current row if there is a value in the same row column c -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date comparisons within AND() functions | Excel Worksheet Functions | |||
Determine year over year date for comparison | Excel Worksheet Functions | |||
Formula For Date Comparisons | Excel Discussion (Misc queries) | |||
How can the date be automated? | Excel Discussion (Misc queries) | |||
Excel 2002 automated annual date change | Excel Discussion (Misc queries) |