| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Thanks everyone for responses.
"Ashish Mathur" wrote in message ... Hi, You can use an array formula (Ctrl+Shift+Enter) to solve your problem. =sum(if((a1:a150="rx")*(b1:b150="oem"),1,0)) Regards, Ashish Mathur "Ed Gregory" wrote: I have a range a1:a150 that can contain"rx". I have a second range b1:b150 that can contain "oem" I want to count the occurrences when a1:a150 contains "rx" AND b1:b150 contains "oem". The key is AND. Right now I use countif to return number of number occurrences for each range, but I need a third count and that is when both are true return a count. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count something that has two fields that must be true | Excel Discussion (Misc queries) | |||
| Count if 2 conditions are true | Excel Worksheet Functions | |||
| returning a count if two conditions are met | Excel Worksheet Functions | |||
| count unique with conditions | Excel Worksheet Functions | |||
| How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions | |||
Threaded Mode
