Monthly Totals

Originally Posted by Glenn Kennedy

I'd move the summary to the top, put months as 01/01/2015, formatted as mmmm to look like January, starting in D2 down to December in D13 and use this formula:

=IF(SUMIFS(E$21:E$301,$D$21:$D$301,">="&$D2,$D$21:$D$301,"<="&EOMONTH($D2,0))=0,"",SUMIFS(E$21:E$301,$D$21:$D$301,">="&$D2,$D$21:$D$301,"<="&EOMONTH($D2,0)))

copied across and down.

See attached.

Okay, I see that it works, but.... (and maybe i'm just being greedy) I want to know WHY and HOW it works. I can probably do this on my own by breaking it apart and trying to recreate it in different sheets. Thank you so much for your quick reply, and while I hate the monthly totals at the top (I just do, i don't know why) I see how it can be benificial (ie incorporating all future values in certain columns into the formulas etc)

again, thank you thank you thank you! I think you just created a monster, i'm going to be on this forum until all of my spreadsheets are flawlessly awesome. Now teaching my GF (Co-worker) these things will be the true test!

Excellent! I will mark this solved and distribute appropriate kudos accordingly! Thanks again to everyone who gave their input!