Hi Everyone!
I'm trying to calculate a column containing: Compliant, Non Compliant & N/A
When I use this formula, it isn't working properly....
=COUNTIF(AC8:AC65536,"COMPLIANT") + COUNTIF(AC8:AC65536,"NON COMPLIANT") + COUNTIF(AC8:AC66536, "N/A")
Any suggestions?
Bookmarks