Count cells that are not blank but exclude any cells that have 'NA'

Victoria Ganuelas

Trying to create a formula that will counts cells in a column that have an entry but not any cells that have 'NA'

Paul Newcome

Try this...

=COUNTIFS([Column Name]:[Column Name], AND(@cell <> "", @cell <> "N/A"))

Paul Newcome

Try this...

=COUNTIFS([Column Name]:[Column Name], AND(@cell <> "", @cell <> "N/A"))

Victoria Ganuelas

Worked perfect! Thank you Paul!

Paul Newcome

Happy to help. 👍️