Count Occurances if two conditions true
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.
|