Question on LABEL Range

[Sarah Tanembaum]

In a LABEL Range(say that it has 12 elements row-wise), how do one refer
to the 4th elements?

I have this ideas that in a worksheet, I have 12 rows single column
LABELED range called MONTHS, where 1st elements is JAN(that is C6), and
so on, and last element would be DEC(C17).

How do I get the 4th element which will be APR, and put that value in
the different cell using the LABEL reference instead of the absolute
cell location(C9)?

Thanks

 

[Guest]

I am not sure I understand your question? You refer to the labels with their
names, so if you want to sum the April row you use

=SUM(Apr)

Otherwise you can use INDEX(MyTable,4,1)

that will return Apr from a table called MyTable

Regards,

Peo Sjoblom

 

[Debra Dalgleish]

If the range is named Months, you can use the INDEX function to get the
fourth item. For example: =INDEX(Months,4)