Help with SUMIF

[Tom]

I have a formula that uses SUMIF to calculate billing for different customers
=SUMIF(Mar!$C$2:$C$999,"Bass*",Mar!$G$2:$G$999), which is working fine. A
company changed it's name so now I need to look for 2 conditions
so it should look for "Bass*" or "Barb*". Is there a way to do this or
another function that can evaluate 2 conditions and add if either is true?

 

[Ron Rosenfeld]

I have a formula that uses SUMIF to calculate billing for different customers
=SUMIF(Mar!$C$2:$C$999,"Bass*",Mar!$G$2:$G$999), which is working fine. A
company changed it's name so now I need to look for 2 conditions
so it should look for "Bass*" or "Barb*". Is there a way to do this or
another function that can evaluate 2 conditions and add if either is true?

=SUMIF(Mar!$C$2:$C$999,"Bass*",Mar!$G$2:$G$999) +
SUMIF(Mar!$C$2:$C$999,"Barb*",Mar!$G$2:$G$999)
--ron

 

[FSt1]

hi
easiest way would be to have 2 sumifs in the same cell i
=SUMIF(Mar!$C$2:$C$999,"Bass*",Mar!$G$2:$G$999)+SUMIF(Mar!$C$2:$C$999,"Barb*",Mar!$G$2:$G$999)

another way might be to use sumproduct.
=SUMPRODUCT((Mar!G2:G999)*((Mar!C2:C999="Bass")+(Mar!C2:C999="Barb")))


Regards
FSt1

 

[RagDyer]

Easiest way is probably:

=SUM(SUMIF(Mar!C2:C999,{"Bass*","Barb*"},Mar!G2:G999))

 

[Tom]

thanks RD, that was what I was looking for

Easiest way is probably:

=SUM(SUMIF(Mar!C2:C999,{"Bass*","Barb*"},Mar!G2:G999))

 

[Howard]

if u r using the Excel 2007, there is a new function = sumifs whereby you can
have more than one conditions

 

[RagDyer]

You're welcome, and appreciate the feed-back.