Formula Help

AMSL

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

Paul Newcome

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

Paul Newcome

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

AMSL

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

Paul Newcome

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

AMSL

Thank you!!

Paul Newcome

Happy to help. 👍️