View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
zvkmpw zvkmpw is offline
external usenet poster
 
Posts: 153
Default counting text based cells

XY A B C A B B A C 3
XX B C A B C A C B 2
I need to count "A" and sumarize it at end of row i.e. 3


Looks like a job for COUNTIF, maybe something like
=COUNTIF(A1:K1,"A")

Modify as needed.