SUM IF FORMULA BASED ON CURRENT/PREVIOUS/NEXT Month

Dear All

I have attached a spreadsheet I am currently working on. I have a list of dates and a list of revenue. I would like to use a SUMIF formula to total up the revenue for specific months, however it goes slightly further then this. I have listed the month buckets I require in A2:D7.

B2 - I need the sum of all revenues that are prior to todays month (i.e before march), please note that I want to use the today function so that the formula can be future proof i.e in April it will automatically total all fees prior to april, without me having to edit the formula.
D2 - will show the sum of all revenues in March (todays month) I have already tried using the formula: =SUMIF(D9:D1000,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),1),E9:E1000)-SUMIF(D9:D1000,">"&DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),E9:E1000)
however this sum of 2,576 does not reconcile with the sum i get of 2,270 when adding manually.
D3 - will show the sum of all revenues in the NEXT (April) month i.e todays month +1 month
D4 - will show the sum of all revenues in the SECOND NEXT (May) month i.e todays month +2 month

The rest of the buckets are self explanatory, sum of all fees between june and august in D5. D6 will show the sum of all revenues in august onwards.

If you could populate the table and re-attach that will be a great help.

Please let me know if you have any other questions.

Thanks,
AK

Thanks ETAF. Those work great. Is it possible for anyone to complete the rest of the date buckets.

1)Past due date - before todays month
2) June - August - I have used =SUMIFS($M$9:$M$1000,$J$9:$J$1000,">="&DATE(YEAR(TODAY()),MONTH(TODAY())+3,1),$J$9:$J$1000, "<="&EOMONTH(TODAY(),3))+SUMIFS($M$9:$M$1000,$J$9:$J$1000,">="&DATE(YEAR(TODAY()),MONTH(TODAY())+4,1),$J$9:$J$1000, "<="&EOMONTH(TODAY(),4))+SUMIFS($M$9:$M$1000,$J$9:$J$1000,">="&DATE(YEAR(TODAY()),MONTH(TODAY())+5,1),$J$9:$J$1000, "<="&EOMONTH(TODAY(),5))
for this which seems to work however if there is a simpler version would be helpful to understand.
3) August + - i.e anything after august

Thanks ETAF. June - August works great however August onwards seems to be giving me an incorrect value. Would it be possible to populate the spreadsheet so I can get a better look?

Also what about the past due date bucket?

Thanks again!

Thank you so much for all your help it is greatly appreciated!

One last point, i'd like to replace =Today() within the formula to a cell reference which will contain a date within it. i.e cell A2 will have a date, rather then having TODAY, it will point to the cell with a date. I've tried but excel doesnt seem to accept my formula.

works great thanks so much