OR within Criteria of SUMIF

[Pekka Numminen]

Is it possible to use the logical function OR within the "Criteria"
argument of SUMIF? If so, how?

 

[Don Guillett]

You can with SUMPRODUCT

={"a","b"}

 

[T. Valko]

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.