Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
counting text same cell multiple worksheets | Excel Discussion (Misc queries) | |||
Counting multiple cells containing text. | Excel Worksheet Functions | |||
counting text across multiple columns | Excel Worksheet Functions | |||
Counting text in multiple cells. | Excel Worksheet Functions | |||
Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions |