| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CountIF on two conditions
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif using two conditions | Excel Discussion (Misc queries) | |||
| COUNTIF with two conditions | Excel Worksheet Functions | |||
| Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
| Countif with two conditions | Excel Discussion (Misc queries) | |||
| Using countif with 2 conditions | Excel Worksheet Functions | |||
Linear Mode
