Are you able to post the example file?
I still have no idea what you are doing with the different sheets as you didn't answer my question, so I'll offer this:
Option A (for data kept all on the same sheet)
For 12 months
For 90 days change the 365 to a 90.
Note that you can extend the range areas, but you need to keep the sum range and criteria range (the date) the same size.
Also note that this formula works for whatever the date is TODAY. You can also swap the TODAY() for a cell reference containing a date you like
Option B (To pull a total from a range of sheets)
Note that this formula will choose sheets in the order you have them on your tabs. So if you move PAGE30 past PAGE36 it will be skipped.
I hope this helps
Bookmarks