Hi,

If you are using 2007 you can write

=COUNTIFS(A2:A100,"="&B1,A2:A100,"<="&C1,B2:B100, D1)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"NWO" wrote:

Now I'm getting a #NUM after entering the formula. I still appreciate your
help. Help!

"Max" wrote:

Sorry, it should read:
=SUMPRODUCT((A2:A100=B1)*(A2:A100<=C1)*(B2:B100=D 1))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"NWO" wrote:
Received an error on the )*)*( part of the formula.