| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF, use List as a Range
I have a list defined in a cell, using Data Validation.
In another cell I want to use the SUMIF function, and as a range use the list selected in the cell that has the validation. Example: In cell A2 I have used Data Validation, specifying Range Names, I have Range 1, Range 2 and Range 3. In other cell I use the SUMIF function this way: =SUMIF(A2;"X";$C$3:$C$13) But the function doesn't recognize the value in A2 as a range name, how should I specify this. Hope I am clear enough. Thanks in advance. Regards, Emece.- |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF, use List as a Range
Maybe...
=SUMIF(indirect(A2);"X";$C$3:$C$13) Emece wrote: I have a list defined in a cell, using Data Validation. In another cell I want to use the SUMIF function, and as a range use the list selected in the cell that has the validation. Example: In cell A2 I have used Data Validation, specifying Range Names, I have Range 1, Range 2 and Range 3. In other cell I use the SUMIF function this way: =SUMIF(A2;"X";$C$3:$C$13) But the function doesn't recognize the value in A2 as a range name, how should I specify this. Hope I am clear enough. Thanks in advance. Regards, Emece.- -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF, use List as a Range
Perfect :-) Thanks a lot
"Dave Peterson" wrote: Maybe... =SUMIF(indirect(A2);"X";$C$3:$C$13) Emece wrote: I have a list defined in a cell, using Data Validation. In another cell I want to use the SUMIF function, and as a range use the list selected in the cell that has the validation. Example: In cell A2 I have used Data Validation, specifying Range Names, I have Range 1, Range 2 and Range 3. In other cell I use the SUMIF function this way: =SUMIF(A2;"X";$C$3:$C$13) But the function doesn't recognize the value in A2 as a range name, how should I specify this. Hope I am clear enough. Thanks in advance. Regards, Emece.- -- Dave Peterson . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
| SumIf - when I fill down the Range, Criteria & sum range changes | Excel Worksheet Functions | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Linear Mode
