When I'm using a SUMIFS formula, I need to reference a specific month from a wider range of dates.

William Oldfield

How do I do this?

David Joyeuse

Hi @William Oldfield

Your formula seems a little bit bugged.

According to what you say this one would work for September:

=SUMIFS({Recycle Range}, {Date Range}, MONTH(@cell)=9)

This will add the recycle tonnage for September.

Hope it helped!

David Tutwiler

Can you be more specific? Maybe include a screenshot or what you've gotten to with your formula so far?

If you're looking to extract a Month out of a date field, you can use the MONTH() function and it will return a number (1-12) representing the month in the date field.

William Oldfield

Thanks for offering a solution David.

What I'm looking for is a means to extract a dataset from a database that relates to a specific month. In my requirement this is recycling tonnage for September as an example. We capture the dates of site decommissions and the amount of waste that is recycled for each date. The dates are held in one column in MM/DD/YYYY format and the recycling tonnage for each date is held in another column in simple number format.

My thought is that the SUMIFS could add the values of the recycling tonnage, I could use the formula of:

=SUMIFS({Recycle range}, {Date range}, {Date Range}, >DATE(2020, 9, 1), {Date Range}, <=DATE(2020, 9, 30))

Needless to say, that doesn't work!

Any help gratefully received. 🙏

David Joyeuse

Hi @William Oldfield

Your formula seems a little bit bugged.

According to what you say this one would work for September:

=SUMIFS({Recycle Range}, {Date Range}, MONTH(@cell)=9)

This will add the recycle tonnage for September.

Hope it helped!

William Oldfield

Thanks to the two David's for their help here. The David Joyeuse solution works (and on reflection seems so simple!)

Many thanks to both of you!