data ranges

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

greg - 15 Jan 2007 17:39 GMT

Hello,
I would like to define a named range
such as D5, D6, D7 as the range.
I define it as test1.
And I want to reference it somewhere else.
Say F8 (=test1)

But I want F8 to be the sum of all of these numbers in the range.
Is there a way to do this.
Besides making a different named cell D8 as the sum of D5-D7?

thanks

Reply to this Message

Don Guillett - 15 Jan 2007 17:47 GMT

=sum(test1)

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hello,
> I would like to define a named range
[quoted text clipped - 8 lines]
>
> thanks

Reply to this Message

Bob Phillips - 15 Jan 2007 17:47 GMT

Range("D5:D7").Name = "myRange"

Range("F8").value = Application.Sum(Range("myRange"))

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

> Hello,
> I would like to define a named range
[quoted text clipped - 8 lines]
>
> thanks

Reply to this Message

greg - 15 Jan 2007 18:01 GMT

Thanks all
I will take a look

> Hello,
> I would like to define a named range
[quoted text clipped - 8 lines]
>
> thanks

Reply to this Message

Earl Kiosterud - 15 Jan 2007 18:01 GMT

Greg,

Insert - Name - Define. In the box, enter test1. In "Refers to:" put:

=SUM(Sheet1!$D$5:$D$7) or
=SUM(Sheet1!$D$5,Sheet1!$D$6,Sheet1!$D$7)

In either case, you can click or drag the cells after clicking into the
"Refers to" box instead of typing the cell references.

Click "Add"

Signature

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

> Hello,
> I would like to define a named range
[quoted text clipped - 8 lines]
>
> thanks

Reply to this Message

Rate this thread: