# Calculating Percentage in "Administrative Column")

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

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

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

• Thanks much. Works like a charm

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!