SUMIF, use List as a Range

E

Emece

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.-
 
D

Dave Peterson

Maybe...

=SUMIF(indirect(A2);"X";$C$3:$C$13)


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.-
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif & Sort 3
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
SUMIF Range 8
SUMIF using 2 cells that equal each other 1
Indirect and sumif functions with multiple workbooks 1
Excel VBA 1
Sumif formula 4
Enter number (data) into cells but want to show different data 3

Top