| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use a named range in the criteria for a sumif?
I would like to use a test of <RANGENAME in the criteria section of a sumif
function? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I use a named range in the criteria for a sumif?
There is a very easy way to find out ... try it.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "rftmst" wrote in message ... I would like to use a test of <RANGENAME in the criteria section of a sumif function? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I use a named range in the criteria for a sumif?
Just concatenate the comparison operator to the range.
=SUMIF(rng1,"<" & rangename,rng2) "rftmst" wrote in message ... I would like to use a test of <RANGENAME in the criteria section of a sumif function? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| named range with criteria. | Excel Worksheet Functions | |||
| Help with SUMIF using a range of dates as criteria | Excel Discussion (Misc queries) | |||
| sumif when criteria is a range | Excel Discussion (Misc queries) | |||
| SUMIF with AND for range and criteria | Excel Worksheet Functions | |||
| SUMIF multiple criteria in 1 range | Excel Worksheet Functions | |||
Linear Mode
