| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
Threaded Mode
