Calculating Percentage in "Administrative Column")

Vinton Douglas

Good day Smarters,

Any help would be appreciated.

I have three columns

1. Status Column with Symbols: RED, Green and Yellow
2. Category of Staff column which is a drop down, one of which is Administrative Staff among others
3. Administrative Staff Column (fixed) to indicate my calculation(%) below

Question: How do I create a formula to reflect the % of Administrative Staff which are Green and Yellow? i.e (Green + Yellow)/ (Green + Yellow + Red).

Thanks in advance

Paul Newcome

You would use a COUNTIFS to get the count of green and yellow then divide it by another COUNTIFS that counts all rows. It would look something like the below:

=COUNTIFS(Category:Category, @cell = "Administrative Staff", Status:Status, OR(@cell = "Green", @cell = "Yellow")) / COUNTIFS(Category:Category, @cell = "Administrative Staff")

Paul Newcome

You would use a COUNTIFS to get the count of green and yellow then divide it by another COUNTIFS that counts all rows. It would look something like the below:

=COUNTIFS(Category:Category, @cell = "Administrative Staff", Status:Status, OR(@cell = "Green", @cell = "Yellow")) / COUNTIFS(Category:Category, @cell = "Administrative Staff")

Vinton Douglas

Thanks much. Works like a charm

Paul Newcome

Happy to help. 👍️