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.