Thread: Problem with COUNT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cong Nguyen Cong Nguyen is offline
external usenet poster
  
Posts: 20
Default Problem with COUNT
In cell B1: I wanted to count the number of commas (,) in cell A1

A, B, C, D, F, G, H 2

Please check what's wrong with my COUNT formula, COUNTA(A1,","), somehow the
result is always "2".

Thank you

--
Cong Nguyen
Reply With QuoteReply With Quote