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.

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.

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.

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.

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

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

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

In article ,
"Matt" wrote:

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

This is getting irritating!!!

You'll get that error if you're using whole column references.
SUMPRODUCT doesn't accept them. You could change the reference to a
'near' whole column reference, such as B2:B65536.

Hope this helps!

Thanks, that took away the #num error, but now it's not totaling. It has to
do something with the date because when I run the formula with two text
columns it works, but when I change it to one text column and then also
looking for a date, it comes out with a zero amount.

"Domenic" wrote:

In article ,
"Matt" wrote:

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

This is getting irritating!!!

You'll get that error if you're using whole column references.
SUMPRODUCT doesn't accept them. You could change the reference to a
'near' whole column reference, such as B2:B65536.

Hope this helps!