Thread: Sum If
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 180
Default Sum If

Since the two conditions are mutually exclusive, you can just add the results
of each:
=sumif(a:a,"BOX549",b:b)+sumif(a:a,"BOX980",b:b)
--Bruce

"carl" wrote:

I need to sum COLB if COLA = BOX549 or BOX980

BOX549 70601
BOX919 60254
BOX017 45468
BOX980 24232

Thank you in advance.