View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf MyVeryOwnSelf is offline
external usenet poster
 
Posts: 213
Default 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")