Countifs for two criteria

Hi! I'm trying to do countifs for two different columns on a sheet, to account for how many of each Project Status type (In Progress, Backlog, Not Started, etc) there are for each Project Lead in my sheet.

I'm wanting to use this info so I can create a dashboard chart based off of the data. I tried the following, but keep getting unparseable.

=COUNTIFS({Reporting Request Tracking Range 4}, "Alex", [{Reporting Request Tracking Range 6}, "In Progress"])

Find more posts tagged with

Accepted answers

Carson Penticuff

=COUNTIFS({Reporting Request Tracking Range 4}, "Alex", {Reporting Request Tracking Range 6}, "In Progress")

All comments

Carson Penticuff

=COUNTIFS({Reporting Request Tracking Range 4}, "Alex", {Reporting Request Tracking Range 6}, "In Progress")

Paul Newcome

You don't need those [Square Brackets] in there.

The help article that shows them uses them to indicate that the second range/criteria set is optional, but they should not be included in the actual formula itself.

alexandra.richardson

Amazing, thank you both!

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.