Help excluding some info from counta formula
I have a column that includes a check mark symbol or N/A. I'd like the
checkmarks to in each section to add
together and populate another worksheet with the number of checkmarks
in each column.
How can I adjust the counta formula or use another formula to only
consider the checkmarks, not anything with n/a...is this possible?
One possible way to get started:
=COUNTA(A:A)-COUNTIF(A:A,"N/A")
|