Guys, what would cause me to get a #Num error when doing this function??

This is getting irritating!!!



"Lost at Work" wrote:

You folks are the greatest!!!

Thank you!!
--
Lost at Work


"cvolkert" wrote:


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