Forum Discussion
Sumifs and Dates
I am trying to use the SUMIFS function but am unsure how to include the day and month as one of the criteria. I tried "5/1-5/31" and even listed all the days and set it as "K1:K30" but neither works....
Let's say you want sum values in B2:B100 for which the corresponding date in D2:D100 is in May 2024:
=SUMIFS(B2:B100, D2:D100, ">="&DATE(2024, 5, 1), D2:D100, "<"&DATE(2024, 6, 1))