Here you go - not sure what you want to sum, but I'll assume column H
for the sake of this formula - change as needed:
=sumproduct((B25:B60 = "Sports")*(C25:C60 = "New")*(G25:G60 =
"11/1/2004"*1)*H25:H60)
Let me know if this doesn't work or if you have more questions - Chad
--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile:
http://www.excelforum.com/member.php...o&userid=24380
View this thread:
http://www.excelforum.com/showthread...hreadid=380735