Add what? Or count?

=SUMPRODUCT(--(B25:B60="Sports"),--(C25:C60="New"),--(G25:G60=--"2004-01-11"
))

--
HTH

Bob Phillips

"lost at work" <lost at wrote in message
...
Need help! I need to have the following put into a function:
If B25:B60 = "Sports" and C25:C60 = "New" and G25:G60 = "11/1/2004" then
add
only those that meet all three criteria.

Thanks to the great brain that helps.