| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I do a "between" in an IF statement?
I need to sum a column and the condition has multiple criteria:
SUMIF($G$16:$G$28, between 5 and 10, $E$16:$E$28) how do I represent "between 5 and 10"? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I do a "between" in an IF statement?
=sumproduct((g16:g28=5)*(g16:g28<10)*e16:e28)
-- Don Guillett SalesAid Software "MojoBaer" wrote in message ... I need to sum a column and the condition has multiple criteria: SUMIF($G$16:$G$28, between 5 and 10, $E$16:$E$28) how do I represent "between 5 and 10"? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I do a "between" in an IF statement?
Thanks, Don! It worked great.
sumproduct? never in a million years would I have figured that out.... "Don Guillett" wrote: =sumproduct((g16:g28=5)*(g16:g28<10)*e16:e28) -- Don Guillett SalesAid Software "MojoBaer" wrote in message ... I need to sum a column and the condition has multiple criteria: SUMIF($G$16:$G$28, between 5 and 10, $E$16:$E$28) how do I represent "between 5 and 10"? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I do a "between" in an IF statement?
"MojoBaer" wrote in message
... I need to sum a column and the condition has multiple criteria: SUMIF($G$16:$G$28, between 5 and 10, $E$16:$E$28) how do I represent "between 5 and 10"? I thin you need an AND(___<10, ___5) in there Beege |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I do a "between" in an IF statement?
Or you can do this.. =SUMIF($G$16:$G$28,"=5")-SUMIF($G$16:$G$28,"10") -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=556554 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I do a "between" in an IF statement?
Bearacade wrote:
Or you can do this.. =SUMIF($G$16:$G$28,"=5")-SUMIF($G$16:$G$28,"10") A m-u-c-h more intuitive expression. KISS! Of course you meant sumif(..., $E$16:$E$28) in both cases; a minor omission. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I do a "between" in an IF statement?
Wrote: Bearacade wrote: Or you can do this.. =SUMIF($G$16:$G$28,"=5")-SUMIF($G$16:$G$28,"10") A m-u-c-h more intuitive expression. KISS! Of course you meant sumif(..., $E$16:$E$28) in both cases; a minor omission. Aye yes, hehe. Thanks for catching that mistake =) -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=556554 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I do a "between" in an IF statement?
A m-u-c-h more intuitive expression. KISS!
why do you think that is better than learning to use sumproduct? -- Don Guillett SalesAid Software wrote in message oups.com... Bearacade wrote: Or you can do this.. =SUMIF($G$16:$G$28,"=5")-SUMIF($G$16:$G$28,"10") A m-u-c-h more intuitive expression. KISS! Of course you meant sumif(..., $E$16:$E$28) in both cases; a minor omission. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I do a "between" in an IF statement?
did you test?
-- Don Guillett SalesAid Software "Beege" wrote in message ... "MojoBaer" wrote in message ... I need to sum a column and the condition has multiple criteria: SUMIF($G$16:$G$28, between 5 and 10, $E$16:$E$28) how do I represent "between 5 and 10"? I thin you need an AND(___<10, ___5) in there Beege |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If Statement linked to cell with VLOOKUP problem - getting wrong v | Excel Worksheet Functions | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| Statement | Excel Worksheet Functions | |||
Hybrid Mode
