Thanks Barb!! I used your formula, but now am getting #N/A!. Also, should
have mentioned, my range names are a formula so they are dynamic, which is as
follows:

PHYNO =OFFSET(all07_08!$F$2,0,0,COUNTA(all07_08!$F:$F),1 )
SURGDT =OFFSET(all07_08!$A$2,0,0,COUNTA(all07_08!$A:$A),1 )
TYPE =OFFSET(all07_08!$C$2,0,0,COUNTA(all07_08!$C:$C),1 )



"Barb Reinhardt" wrote:

Try this

=SUMPRODUCT((SURGDT=Date(year(AH2),month(AH2),day (AH2)))*(PHYNO=B3)*(TYPE="INPT"))

--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Tasha" wrote:

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...