Reference a sheet and count the number of a specific health icon based on status.

Hello,

I am referencing a project schedule in a sheet where I am counting the total number of rows that have a specific health icon color. Green, Yellow, and Red were all straightforward to get totals for. My formula for those is: =COUNTIF({Project Schedule - Health Column}, [Health Icon]4) for each different health icon.

I also have a gray health icon in the mix, and I would only like to count those gray health icons that do not have a status of "N/A". For reference see a screenshot of the different options I have in the dropdown list for "Status".

Screen Shot 2022-11-21 at 2.18.38 PM.png

I think that I would need to use the =COUNTIFS formula, but I am struggling to bring in the criteria for not counting tasks with a gray health and a status of "N/A". Any help on this would be greatly appreciated! Thanks!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You would use something like this:

=COUNTIFS({Health}, @cell = "Gray", {Status}, @cell <> "N/A")

All comments

Paul Newcome

You would use something like this:

=COUNTIFS({Health}, @cell = "Gray", {Status}, @cell <> "N/A")

Alec S.

Thanks Paul, this worked for me! I appreciate the help.

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.