Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with function
=SUMIF(Reason,(OR("B Scale",B Scale Night)),M20:M33)
I am trying to sum cells in column M20:M33 if the named cells "Reason" contain the words "B Scale" or "B Scale Night" What am I doing wrong? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with function
A good way to understand why a formla does not return expected result is to
select part of it and press F9, which then replaces the formula by its result. In your case, if you select the OR(...) part, you see that Excel does not like it very much. May be it is because of the missing quotes around the second argument? No, still no luck. In fact OR function only works with numbers, so in your case you should proceed differently and add two SUMIF: =SUMIF(Reason,"B Scale",M20:M33) + SUMIF(Reason,"B Scale Night",M20:M33) "Barb" wrote: =SUMIF(Reason,(OR("B Scale",B Scale Night)),M20:M33) I am trying to sum cells in column M20:M33 if the named cells "Reason" contain the words "B Scale" or "B Scale Night" What am I doing wrong? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with function
Try one of these:
The 2-part method =SUMIF(Reasons,"b scale",M20:M33)+SUMIF(Reasons,"b scale night",M20:M33) The combined 2-part method =SUM(SUMIF(Reasons,{"b scale","b scale night"},M20:M33)) If you need to sum any cell beginning with "b scale" =SUMIF(Reasons,"b scale*",M20:M33) Does that help? (Post back if you have more questions) *********** Regards, Ron XL2003, WinXP "Barb" wrote: =SUMIF(Reason,(OR("B Scale",B Scale Night)),M20:M33) I am trying to sum cells in column M20:M33 if the named cells "Reason" contain the words "B Scale" or "B Scale Night" What am I doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DBSUM function but with function as criterion, not a range | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |