# Counting yes and yes w/notes

✭✭✭

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

## Best Answer

• ✭✭✭✭✭✭
Answer ✓

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

## Answers

• ✭✭✭✭✭✭
Answer ✓

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

• ✭✭✭

Thank you Paul, that helped a lot!

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!