| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF with a reference to a cell
I'm trying to write a sumif function where I add something if it is smaller
than or equal to a particular number. However, when I do this I need to write the number in, instead of referencing the cell where the number is located. Is there something extra I need to do. This is what my formula looks like right now. =SUMIF($T$9:$T$13,"<=13.5",$S$9:$S$13) I want that 13.5 to be a cell, but excel is not working properly when I just click on the cell. What can I add to the formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF with a reference to a cell
=SUMIF($T$9:$T$13,"<="&U9,$S$9:$S$13)
-- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "conny" wrote in message ... I'm trying to write a sumif function where I add something if it is smaller than or equal to a particular number. However, when I do this I need to write the number in, instead of referencing the cell where the number is located. Is there something extra I need to do. This is what my formula looks like right now. =SUMIF($T$9:$T$13,"<=13.5",$S$9:$S$13) I want that 13.5 to be a cell, but excel is not working properly when I just click on the cell. What can I add to the formula? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF with a reference to a cell
Thanks
"Sandy Mann" wrote: =SUMIF($T$9:$T$13,"<="&U9,$S$9:$S$13) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "conny" wrote in message ... I'm trying to write a sumif function where I add something if it is smaller than or equal to a particular number. However, when I do this I need to write the number in, instead of referencing the cell where the number is located. Is there something extra I need to do. This is what my formula looks like right now. =SUMIF($T$9:$T$13,"<=13.5",$S$9:$S$13) I want that 13.5 to be a cell, but excel is not working properly when I just click on the cell. What can I add to the formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I set the criteria in a sumif statement as a cell reference? | Excel Worksheet Functions | |||
| Using SUMIF Function with a named cell reference as value in CRITE | Excel Worksheet Functions | |||
| I want to use sumif( a cell reference) and not a value. How? | Excel Worksheet Functions | |||
| How do you reference another cell in the criteria of a SUMIF funct | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Linear Mode
