View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aaron G Aaron G is offline
external usenet poster
 
Posts: 1
Default Counting Multiple Text Cells

I am trying to determine the formula to count - only if the criteria in two
(or more) cells is true.

Example Data Set

Service Equipment
Data ATM
Voice DMS 250
Voice DMS 300
Data FR
Voice DMS 250

So i am looking for something to show how often both the serivce and the
equipment criteria meet the desired output.

I tried writing a formula like =COUNTIF(A2:A6,"Voice")AND(B2:B6,"DMS250")

where it would then count the data set and report the value of 2 ... 2 times
the criteria is both voice and dms250.

Any thoughts???

Thanks