named cells as sum of rows?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg - 04 Oct 2006 17:15 GMT

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

Reply to this Message

Dave Peterson - 04 Oct 2006 17:22 GMT

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).
On sheet "inventory"

> Hello,
> I am looking at a excel sheet. And see formulas suchas this
[quoted text clipped - 14 lines]
>
> thanks for any help

Signature

Dave Peterson

Reply to this Message