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

Alec S.

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".

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!

Paul Newcome

You would use something like this:

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

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. 👍️