Posted to microsoft.public.excel.misc

external usenet poster

Posts: 28

variable reference ranges

Hi - I want to write a formulae where the reference range is variable. For
example, =average(c3:c(3+variable number)). I would really like to do this
by referencing another cell for the variable number. Is this possible, I
have tried a number of approaches but am getting no joy.
Thanks
SC.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selecting Variable Data Ranges	rc	Excel Discussion (Misc queries)	2	May 18th 07 08:26 PM
Sorts on variable ranges	bman342	Excel Worksheet Functions	1	June 28th 06 08:46 PM
Variable ranges	John Contact	Excel Worksheet Functions	1	June 17th 05 08:02 AM
Sum Variable Ranges	Erika	Excel Worksheet Functions	6	December 23rd 04 03:52 PM
Variable Print Ranges	Zshepherd	Excel Discussion (Misc queries)	0	December 2nd 04 03:23 PM

All times are GMT +1. The time now is 12:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us