View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darin Kramer Darin Kramer is offline
external usenet poster
 
Posts: 397
Default 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 ***