Counting yes and yes w/notes

ksandoval

Hello,

I am having trouble counting using the COUNTIFS formula to yes's and another category called "Yes w/notes". Here is the current formula that I have:

• =COUNTIFS([Are all workers wearing the proper PPE?]@row:[Is there a permit required?]@row, @cell = "Yes") / COUNTIFS([Are all workers wearing the proper PPE?]@row:[Is there a permit required?]@row, AND(@cell <> "n/a"))

It means mentions "N/A" because I did not want that increasing or decreasing the percentage.

The only categories that should be affecting it are "YES" and "YES W/NOTES" to increase the percentage, but also count "NO" and "NO W/NOTES" to decrease the percentage. But someone selects "YES W/NOTES" it decreases the percentage when it should increasing it.

If someone can get back to me as soon as possible, that would be great.

Thank you

Paul Newcome

Try this:

=COUNTIFS([Are all workers wearing the proper PPE?]@row:[Is there a permit required?]@row, OR(@cell = "Yes", @cell = "Yes w/Notes")) / COUNTIFS([Are all workers wearing the proper PPE?]@row:[Is there a permit required?]@row, @cell <> "n/a")

Paul Newcome

Try this:

=COUNTIFS([Are all workers wearing the proper PPE?]@row:[Is there a permit required?]@row, OR(@cell = "Yes", @cell = "Yes w/Notes")) / COUNTIFS([Are all workers wearing the proper PPE?]@row:[Is there a permit required?]@row, @cell <> "n/a")

ksandoval

Thank you Paul, that helped a lot!

Paul Newcome

Happy to help. 👍️