SUMIF with OR
Try:
=SUMPRODUCT((B2:B40="DSO")+(B2:B40="OOJ"),(C2:C40) )
--
Gary''s Student - gsnu200810
"dave roth" wrote:
Good morning:
I'm running XL 2007, SP1 under WinXP.
I need to sum a range based on whether another range is either "DSO" or
"OOJ", i.e =SUMIF(OR(B$2:B$40="DSO","OOJ",),C$2:C$40)This formula obviously
doesn't work, and I can't seem to get the syntax correct. Should I be using
the double hyphen here?
Thank you for your assistance.
|