I assume that you mean H25:H60

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


--
HTH

Bob Phillips

"Lost at Work" wrote in message
...
Oops! Add total of visitors H25:G60

Thanks,
--
Lost at Work


"Bob Phillips" wrote:

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.