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

Options

Best Answer

Answers

  • David Tutwiler
    David Tutwiler Overachievers Alumni
    Options

    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
    Options

    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. 🙏

  • William Oldfield
    Options

    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!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!