SUMIFS for prior month


I've been trying to figure this one out for a while and cannot get it to work. We want to have a count of how many RFPs meet criteria for the prior month (without having to filter on a report every time). Is this possible? Here's what I have for the simplest one, but it is not giving me the correct number:

=COUNTIFS(Source:Source, CONTAINS("GSD", @cell), [Date Received]:[Date Received], IFERROR(MONTH(@cell), 0) = MONTH(TODAY())-1)

Thank you in advance!

Best Answer

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

    See below:

    =COUNTIFS(Source:Source, CONTAINS("GSD", @cell), [Date Received]:[Date Received], OR(AND(IFERROR(MONTH(@cell), 99) = (MONTH(TODAY()) - 1), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())), AND(IFERROR(MONTH(@cell), 99) = (MONTH(TODAY()) + 11), IFERROR(YEAR(@cell), 0) = (YEAR(TODAY()) - 1))))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!