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.
|