COUNTIF With Parameters in Two Columns

I am trying to create a formula that will count the number of status of 24-72 for the month of Oct 22. I have tried a number of iterations without success.

Example formula tried (yields unparseable)

=COUNTIFS([Month Year]:[Month Year], "Oct 22", [Status:Status], "24-72")

Sheet info

Find more posts tagged with

Accepted answers

All comments

Cory Page

Good morning,

Are you looking for something like I have shown below if not feel free to reply..

=COUNTIFS(Status:Status, ="24-72", [Month Year]:[Month Year], "Oct 22")

Here is a view if you would like a static summary sheet as well.

=COUNTIFS(Status:Status, =[Status (Summary Sheet)]@row, [Month Year]:[Month Year], [Month Year (Summary Sheets)]@row)

Paul Newcome

Try removing the square brackets from around

[Status:Status]

should be

Status:Status

jcurry

Thank you, both!! Removing the brackets was the key. Now I will dig into the version that Cory provided.

Paul Newcome

Happy to help. 👍️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.