Thread: Column Counts
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Column Counts

=COUNTBLANK(C1:C400)
--
David Biddulph

"Brurobiney" wrote in message
...
I have a list of 400 items. In Column C are characters that mean different
things. How do I write up a formula that gives me a count of the items
that
does NOT have a character in column C?