Thread
:
Counting Multiple Text Cells
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
Counting Multiple Text Cells
Try this...
=SUMPRODUCT(--(A2:A6="Voice"),--(B2:B6="DMS250"))
Better to use cells to hold the criteria:
D2 = voice
E2 = DMS250
=SUMPRODUCT(--(A2:A6=D2),--(B2:B6=E2))
If you're using Excel 2007:
=COUNTIFS(A2:A6,D2,B2:B6,E2)
--
Biff
Microsoft Excel MVP
"Aaron G" <Aaron
wrote in message
...
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
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko