If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 . |
Thread Tools | |
Display Modes | |
|
|