OR within Criteria of SUMIF

  • Thread starter Thread starter Pekka Numminen
  • Start date Start date
P

Pekka Numminen

Is it possible to use the logical function OR within the "Criteria"
argument of SUMIF? If so, how?
 
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.
 
Back
Top