Thread: Help with SUMIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default Help with SUMIF

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?