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!

Find more posts tagged with

Accepted answers

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

All comments

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:

Anna Deschenes

That worked! Thank you so much.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.