Sum column B where column A = Joe OR Sue:

=SUM(SUMIF(A1:A10,{"Joe","Sue"},B1:B10))

=SUMIF(A1:A10,"Joe",B1:B10)+SUMIF(A1:A10,"Sue",B1: B10)

=SUMPRODUCT(--(ISNUMBER(MATCH(A1:A10,{"Joe","Sue"},0))),B1:B10)

=SUMPRODUCT((A1:A10={"Joe","Sue"})*B1:B10)

Array entered** :

=SUM(IF(A1:A10={"Joe","Sue"},B1:B10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Pekka Numminen" wrote in message
...
Is it possible to use the logical function OR within the "Criteria"
argument of SUMIF? If so, how?