Posted to microsoft.public.excel.misc

Eric

external usenet poster

Posts: 1,670

How to use Indirect functions?

Does anyone have any suggestions on how to use Indirect function?
For Example, there is a list of numbers under column A, a given number 20 in
cell B1 and a formula sum(A81:A100)/20 in cell C1.
If I change the number 20 into 30 in cell B1, then the formula will become
sum(A71:A100)/30.
If I change the number 20 into 40 in cell B1, then the formula will become
sum(A61:A100)/40.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

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
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions	Mike Barlow	Excel Worksheet Functions	7	May 21st 23 07:42 PM
INDIRECT & VLOOKUP functions	Tanya	Excel Worksheet Functions	4	October 26th 07 04:51 AM
indirect.ext / pull functions	David	Excel Discussion (Misc queries)	0	September 11th 07 01:29 PM
row-indirect functions	[email protected]	Excel Discussion (Misc queries)	3	February 28th 06 11:01 PM
Offset and Indirect functions	Thrava	Excel Discussion (Misc queries)	4	December 23rd 04 05:07 PM

All times are GMT +1. The time now is 11:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us