Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIF - problem with Criteria
=SUMIF($A$9:$A48,"<=16",D$9:D$48)
The above works. But what I need to do is to have the "<=16" get the variable value 16 from a cell. The cell address with the current value 16 is AH1 and is on the same worksheet. Sorry folks - I can't figure out how to do this. If I enter "<=16", I get the correct value. If I enter "<=AH1", I get 0. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIF - problem with Criteria
=SUMIF($A$9:$A48,"<="&AH1,D$9:D$48)
qwerty wrote: =SUMIF($A$9:$A48,"<=16",D$9:D$48) The above works. But what I need to do is to have the "<=16" get the variable value 16 from a cell. The cell address with the current value 16 is AH1 and is on the same worksheet. Sorry folks - I can't figure out how to do this. If I enter "<=16", I get the correct value. If I enter "<=AH1", I get 0. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIF - problem with Criteria
Try this:
=SUMIF($A$9:$A$48,"<="&AH1,D$9:D$48) Hope this helps. Pete |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIF - problem with Criteria
Thank you. Problem solved.
"Dave Peterson" wrote in message ... =SUMIF($A$9:$A48,"<="&AH1,D$9:D$48) qwerty wrote: =SUMIF($A$9:$A48,"<=16",D$9:D$48) The above works. But what I need to do is to have the "<=16" get the variable value 16 from a cell. The cell address with the current value 16 is AH1 and is on the same worksheet. Sorry folks - I can't figure out how to do this. If I enter "<=16", I get the correct value. If I enter "<=AH1", I get 0. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif with 2 criteria | Excel Discussion (Misc queries) | |||
Multiple Criteria in a SUMIF formula | Excel Discussion (Misc queries) | |||
Sumif with criteria list | Excel Worksheet Functions | |||
SUMIF, multiple criteria | Excel Discussion (Misc queries) | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) |