Running totals with SUMIFS formula - no longer working

[Burrgogi]

I created an excel sheet that contains all the purchases we've made at Costco. The main thing I was interested in was calculating the total grocery expenditures for each month in 2018. The SUMIFS formula that I had for some reason is no longer working.

For reference, I posted a question about this back in September last year and Aladin Akyurek provided the correct formula that was working just fine until recently:

=SUMIFS(K18:K505,G18:G505,"Groc",B18:B505,">="&"1Jun",B18:B505,"<="&EOMONTH("1Jun",0))

I just opened up the workbook a couple of days ago and found out that the running total (for groceries) is now showing $0 for each month. I have a hunch that perhaps the new year (2019) is culprit behind this problem since the workbook was created last year in 2018 but that's just a hunch only and I don't know how to fix this.

Here is a screenshot so you guys know what elements are contained in each column.


Disregard the formula that is showing in the screenshot. It was taken before Aladin Akyurek expertly corrected my formula and gave me the proper one.

Any help would be appreciated.

 

[Marcelo Branco]

Maybe...

=SUMIFS(K18:K505,G18:G505,"Groc",B18:B505,">="&DATE(2018,6,1),B18:B505,"<="&DATE(2018,6,30))

M.

 

[Burrgogi]

Well, some months have 30 days and some have 31. I'd really like something that incorporates the EOMONTH function as before so that i don't need to adjust the formula depending on the number of days. I'm still puzzled why the one provided by Aladin Akyurek before stopped working.

 

[Marcelo Branco]

Well, some months have 30 days and some have 31. I'd really like something that incorporates the EOMONTH function as before so that i don't need to adjust the formula depending on the number of days. I'm still puzzled why the one provided by Aladin Akyurek before stopped working.

Try

=SUMIFS(K18:K505,G18:G505,"Groc",B18:B505,">="&DATE(2018,6,1),B18:B505,"<="&EOMONTH(DATE(2018,6,1),0))

M.
ps: the dates in Aladin's formula refer to the current year, 2019, not to 2018 anymore.

 

[Burrgogi]

That works - I appreciate the quick response Marcelo Branco.