Hi. I typed in =SUMPRODUCT(--(A1:A100={"BOX549","BOX890"}),B1:B100) and get
#N/A. Any ideas ?

Thanks again.

"Bob Phillips" wrote:

=SUMPRODUCT(--(A1:A100=("BOX549","BOX890"}),B1:B100)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"carl" wrote in message
...
I need to sum COLB if COLA = BOX549 or BOX980

BOX549 70601
BOX919 60254
BOX017 45468
BOX980 24232

Thank you in advance.