COUNTIFS function with multiple criteria

I have what I think should be a simple formula, but I only get "#UNPARSEABLE".

I just want to return a count when the WAVE column contains "Wave 2" AND the STATUS column contains "Not Started". My current formula is:

=COUNTIFS({Wave}, "Wave2" AND {Status}, "Not Started")

Find more posts tagged with

Accepted answers

Brent C. Wilson

Try

=COUNTIFS({Wave}, "Wave2", {Status}, "Not Started")

The COUNTIFS function allows you to specify multiple pairs of ranges and criteria. Each pair represents one condition. The function counts only those cells where all specified conditions are met simultaneously.

if you still get errors it could be how you have {Wave} and {Status} defined

=COUNTIFS([Wave]:[Wave], "Wave2", [Status]:[Status], "Not Started")

All comments

Brent C. Wilson

Try

=COUNTIFS({Wave}, "Wave2", {Status}, "Not Started")

if you still get errors it could be how you have {Wave} and {Status} defined

=COUNTIFS([Wave]:[Wave], "Wave2", [Status]:[Status], "Not Started")

murphsa1

Thank you - changing to the following fixed it

=COUNTIFS({Wave}, "Wave2", {Status}, "Not Started")

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.