CountIF on two conditions
 

Hi There


I have a simple countif :
COUNTIF($M$2:$M$7145,Dog)

I want to change it to take account of another conditon. So If in column
P over the same range there is an owner named Jack, then count the
instances of Dog in column M.

There are various owners in column P.

Thanks and Regards

D

*** Sent via Developersdex http://www.developersdex.com ***

CountIF on two conditions
 

Try :
=SUMPRODUCT(($M$2:$M$7145="Dog")*($P$2:$P$7145="Ja ck"))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Darin Kramer" wrote in message
...
Hi There


I have a simple countif :

I want to change it to take account of another conditon. So If in column
P over the same range there is an owner named Jack, then count the
instances of Dog in column M.

There are various owners in column P.

Thanks and Regards

D

*** Sent via Developersdex http://www.developersdex.com ***

CountIF on two conditions
 

Thanks - works perfectly!!! :)


*** Sent via Developersdex http://www.developersdex.com ***

CountIF on two conditions
 

You're welcome !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Darin Kramer" wrote in message
...

Thanks - works perfectly!!! :)


*** Sent via Developersdex http://www.developersdex.com ***