Thread: countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AJ
 
Posts: n/a
Default countif

I want to count the occurrences of multiple character strings eg. "AB" "XD"
and "CD". Is there an easier way than = (countif(1:100), "AB") +
(countif(1:100), "XD") etc.