=SUMPRODUCT(--(((B2:B7="apple")+(B2:B7="orange"))0),C2:C7)


"iampritzy" wrote:

rFor example: SUMIF(B2:B7, "Apple OR Orange", C2:C7) If it's an apple or an
orange, sum their values in column c.
It does not work. Can anyone help?