No Prob. If you dont want intermediate totals then you can use SUM adding each SUMIFS from above for each sheet:
=SUM(SUMIFS(B2:B8,A2:A8,">="&E2,A2 :A8,"<="&E3)+SUMIFS(B2:B8,A2:A8,">="&E2,A2 :A8,"<="&E3)+SUMIFS(B2:B8,A2:A8,">="&E2,A2 :A8,"<="&E3)) etc. Obviously you need to make sure the sheet...
This will add up values based upon a date range on one sheet:
=SUMIFS(B2:B8,A2:A8,">="&E2,A2:A8,"<="&E3)
Where B2:B8 are the values to add up, A2:A8 is the list of dates and E2 and E3 are the start and end dates you want to find. It works, just tried it. Will now try to work out how to sum up...