Names used in formulas

[lovesexcel]

Hi,

I have a workbook with many names and would like to be able to use the name manager and cell references in order to summarize the information.

Is it possible to lookup a name as a cell reference within the formula.

A1 = Salaries (this is also the name of a range)

A2 = Sum(A1)

The data and formula is more complex but I believe this will give me the desired answer.

[popipipo]

=sum(indirect(a1))

[oeldere]

I suggest you work with an pivot table.