OR within Criteria of SUMIF
 

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

OR within Criteria of SUMIF
 

You can with SUMPRODUCT

={"a","b"}

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

OR within Criteria of SUMIF
 

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?