SUMIF with OR
 

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.

SUMIF with OR
 

=SUM(SUMIF(B$2:B$40,{"DSO","OOJ"},C$2:C$40))

--
__________________________________
HTH

Bob

"dave roth" wrote in message
...
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.

SUMIF with OR
 

To sum B values if A column is "a" or "b"
1) =SUMIF(A1:A6,"a",B1:B6)+SUMIF(A1:A6,"b",B1:B6)
or
2) =SUMPRODUCT((A1:A6={"a","b"})*B1:B6)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"dave roth" wrote in message
...
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.

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.

SUMIF with OR
 

Thank you sir.

"Bob Phillips" wrote:

=SUM(SUMIF(B$2:B$40,{"DSO","OOJ"},C$2:C$40))

--
__________________________________
HTH

Bob

"dave roth" wrote in message
...
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.

SUMIF with OR
 

Thank you sir.

"Bernard Liengme" wrote:

To sum B values if A column is "a" or "b"
1) =SUMIF(A1:A6,"a",B1:B6)+SUMIF(A1:A6,"b",B1:B6)
or
2) =SUMPRODUCT((A1:A6={"a","b"})*B1:B6)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"dave roth" wrote in message
...
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.

SUMIF with OR
 

Thank you sir.

"Gary''s Student" wrote:

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.