named cells as sum of rows?

[Dave Peterson]

Names can refer to a single cell or multiple cells (even discontiguous cells).
Names can also refer to formulas and constants.

But in this case, the name refers to:
Inventory!R194C23:R343C23
That's the R1C1 reference style.

It's rows 194:343
and Column 23 (column W).

 

[Greg]

Hello,
I am looking at a excel sheet. And see formulas suchas this
=SUM((Inventory_object_FactorName="# of acquired components -
simple")*(object_scope="In Scope")*(object_no_of_units))

I was looking for the named cell "Inventory_object_FactorName"

However cannot find it.

so I looked at the xml. and see this

<NamedRange ss:Name="Inventory_object_FactorName"
ss:RefersTo="=Inventory!R194C23:R343C23"/>

so does this mean, a named cell can also be a range? where you wont click
into a cell and see the named cell name in the "name box"?

thanks for any help