A
Aaron G
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
(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