Thread: Can you use CountA to add multiple items within one cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default Can you use CountA to add multiple items within one cell?
=COUNTA(A1:A100),"A")+COUNTA(A1:A100,"B")
to count how many As and Bs in the range ?
Or is the question something else?
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Teacher in a quandry" <Teacher in a
wrote in message ...
I need to be able to count items in a column, but also have it add multiple
items with in one cell. Any ideas?


Reply With QuoteReply With Quote