| The quickest way is to do a SORT and then SUBTOTAL for date ranges (which is a built in auto filter and sumif combo).
A fancier way would be to split the date into MONTH() and YEAR() in 2 new columns and then CONCATENATE() the 2 back to get a label like "Jan 2006". Then do as many as you need SUMIF() with the "condition" being "Jan 2006", and "Feb 2006", "March 2006", etc, entered in other cell locations referenced.
The only trick on the SUMIF() is that the calculated condition needs to be to the left of the values to be summed. You can just repeat the values to be added in a new column to the right.
You could also do something with the IF() AND() combo formula =IF(AND(date<=max,date>=min),"yes","no") then SUMIF the "yes".
If you do that stuff often, or want maximum reporting abilities on large volumes of info, you need to look into the Pivot Table function. This is Excel on turbo charge. You can then do nested database look-ups and indexing - fun stuff. Add in named ranges and macros and you're in business.
Good Luck
Last edited by Bass Thunder : 01-10-2008 at 08:25 PM.
| 
