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?