Not calculating last month?!

[debenay]

Hi all! I set up a formula similar to this: =SUMIFS($A:$A,$B:$B,">="&D1,$B:$B,"<="&EOMONTH(D1,0)) to calculate projected costs for current/future months.

However, in the main set of data there HAS to be a problem because it will not calculate the last day of the month for any month.

Any idea what could be wrong? I didn't set up the spreadsheet where the data is pulled from so I don't know where to look!

Thank you

 

[Tetra201]

Try setting it to:

=SUMIFS($A:$A,$B:$B,">="&D1,$B:$B,"<"&(EOMONTH(D1,0)+1))

or, if you have 1st of the month in D1, to:

=SUMIFS($A:$A,$B:$B,">="&D1,$B:$B,"<"&EDATE(D1,1))