Help with SUMIF

  • Thread starter Thread starter Tom
  • Start date Start date
T

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?
 
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?
Click to expand...


=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
 
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
 
if u r using the Excel 2007, there is a new function = sumifs whereby you can
have more than one conditions
 
Back
Top