# Formula Help

I am tracking training participants. I have a drop-down column with "Advanced", "Intermediate", "Beginner", and "N/A" that every participant will be assigned. I'd like a formula (that will be in a different sheet) that would show the percentage of participants that are labeled with any of the following "Advanced", "Intermediate", "Beginner".

• ✭✭✭✭✭✭

So basically you are looking for 100% minus the percentage of "N/A"?

In that case you are going to want something along the lines of...

=COUNTIFS({Reference Sheet Drop Down Column}, AND(@cell <> "N/A", @cell <> "")) / COUNTIFS({Reference Sheet Drop Down Column}, @cell <> "")

• ✭✭✭✭✭✭

Are you wanting one formula to calculate the percentage of all three of those options combined or three separate formulas (one for reach)?

• I was originally looking for one formula; however, if that is not possible, three separate ones would work too!

• ✭✭✭✭✭✭

So basically you are looking for 100% minus the percentage of "N/A"?

In that case you are going to want something along the lines of...

=COUNTIFS({Reference Sheet Drop Down Column}, AND(@cell <> "N/A", @cell <> "")) / COUNTIFS({Reference Sheet Drop Down Column}, @cell <> "")

• Thank you!!

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!