COUNTIF multiple criteria

[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

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(C1:C100="person"),--(B1:B100=DATE(2004,4,1)),--(D1100=
"x-type of work"))

 

[Don Guillett]

try
=sumproduct((b2:b200=date)*(c2:c200="Joe")*(d2:d200="work"))

 

[Dave R.]

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")*(D110="chipping golf balls"))