Thread: Can you use CountA to add multiple items within one cell?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Can you use CountA to add multiple items within one cell?
=SUMPRODUCT(COUNTIF(A1:A100,{"A","B"}))


"Teacher in a quandry" wrote:

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