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.
|