Can anyone please help or knows Excel function for the following. I have 24 periods, now I would like to sum them up just by changing date in one field, so for example if right now is August I would like to sum up only numbers from January through August, next month, when I enter September, I want formula to pick up September amount as well, I tried writting nested if statements but it has limitations, and I also don't want to go into SUM formula and change every month to reflect it.
If anyone know the solution I would really appreciate it.
Sum by Date
No one wants to try to answer this one do they! I have found if you leave a blank row or column between the data and the sum you have "room to play". All you need to do is insert another row or column to keep the blank available. When you do this, the SUM range changes to include the new row or column and when you add data it is included in the result. Hope that helps in some way.
7th Dec 2009