SUMIFS for prior month

Anna Deschenes

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!

Leibel S

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))))

Leibel S

@Anna Deschenes

Try the below:

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

Anna Deschenes

@Leibel S

That returns too high a number.

Leibel S

@Anna Deschenes

Is this a list that goes back more then 12 months?

The formula above does not take into account the year... Do you need that?

Anna Deschenes

@Leibel S - yes it does so I guess I do need to add the year. Thank you!

Leibel S

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))))

Anna Deschenes

That worked! Thank you so much.