Sumproduct & Date multiple criteria
I need to count items that equal a number(B3) range name is PHYNO, and = a
type "INPT" (range name is TYPE), and are greater than 1/1/2008(AH2). The
date is in range name SURGDT and is formatted as *m/d/yyyy. When I try to do
my formula, I get 0. This is the formula I've tried:
=SUMPRODUCT((SURGDT=AH2)*(PHYNO=B3)*(TYPE="INPT") )
Hoping someone can help...
|