COUNTIF multiple criteria

  • Thread starter Thread starter dylaninaz
  • Start date Start date
D

dylaninaz

Hello, I have a problem with a formula. Wondering if anyone could help.

Basically, I have one sheet that queries for External data which the
dumps into the following columns:

Col B - date (in mm/dd/yy format)
Col C - person performing work
Col D - type of ob work done

Basically, I'm trying to set a cell on anotrher worksheet that count
the number of ob works done by one person done on a particular day - s
I need something like:

=countif(cold:c="person", countif(colb:b="date", countif(cold:d="x-typ
of work")))

I know that countif can't do multiple ranges and criteria - I've trie
a SUM(IF(, SUMPRODUCT(, even as an array, but I can't seem to get th
right combo. Any ideas?:mad
 
Hi
try
=SUMPRODUCT(--(C1:C100="person"),--(B1:B100=DATE(2004,4,1)),--(D1:D100=
"x-type of work"))
 
A google groups search for "countif multiple criteria" will result in many
sumproduct solutions.

Here is a simple layout

=SUMPRODUCT((B1:B10=DATEVALUE("3/15/04"))*(C1:C10="OJ
Simpson")*(D1:D10="chipping golf balls"))
 
Back
Top