Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Sumif | Excel Discussion (Misc queries) | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |