Questions

Excel Question - Sum by date when date is not constant

+
0 Votes
Locked

Excel Question - Sum by date when date is not constant

vlevin13
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.
  • +
    0 Votes
    stapleb

    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.

    +
    0 Votes
    PurpleSkys Moderator

    well considering that the original post is over two years old, as is the other Excel post you responded to; one would think they either received the answer they were looking for or at least figured it out by now

  • +
    0 Votes
    stapleb

    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.

    +
    0 Votes
    PurpleSkys Moderator

    well considering that the original post is over two years old, as is the other Excel post you responded to; one would think they either received the answer they were looking for or at least figured it out by now