How to enter a range plus an additional cell in a function.

[Lawrence M. Seldin, CMC, CPC]

I have Win2k with Excel 2000.

I have a functions that uses a calculations such as:

=MvAvg(E3:E12,10,0)

The problem is that instead of using a range of E3:E12.

I really want to use a range with these cells:

B1 E3 E4 E5 E6 E7 E8 E9 E10 E11

How can I do this?


Thanks much,

Lawrence M. Seldin, CMC, CPC
Author of POWER TIPS FOR THE APPLE NEWTON and INTRODUCTION TO CSP
Author of RECRUITSOURCE PEOPLESOFT EXAM and RECRUITSOURCE SAP/R3 EXAM


NOTE: To send me an email, remove TAKEOUT from my email address: (e-mail address removed)

NOTE: My web home page: www.seldin.net

 

[Dave R.]

One way is to select the cells, you know by pressing CTRL and clicking on
them, then go to INSERT>NAME>DEFINE , call them "myrange" then use
=MVAVG(myrange,10,0)

 

[Lawrence M. Seldin, CMC, CPC]

Dave,

Thanks much,

I'll try it.

- Larry



---------------------------------------------------------------------------------

One way is to select the cells, you know by pressing CTRL and clicking on
them, then go to INSERT>NAME>DEFINE , call them "myrange" then use
=MVAVG(myrange,10,0)

Lawrence M. Seldin, CMC, CPC
Author of POWER TIPS FOR THE APPLE NEWTON and INTRODUCTION TO CSP
Author of RECRUITSOURCE PEOPLESOFT EXAM and RECRUITSOURCE SAP/R3 EXAM


NOTE: To send me an email, remove TAKEOUT from my email address: (e-mail address removed)

NOTE: My web home page: www.seldin.net