Posted to microsoft.public.excel.programming

Victor[_3_] Victor[_3_] is offline

external usenet poster

Posts: 7

Indirect reference

I want to calculate an average.
The formula is: AVERAGE(C4:Cx)
X represents the value of: COUNT(C4:C16)and is therefore
variable.
How do I input X value in my AVERAGE formula?

I think it has something to do with INDIRECT but I
couldn't find an example I could apply to my specific
problem.

Thanks in avance

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
INDIRECT reference or ?	Tom	Excel Worksheet Functions	8	April 26th 10 10:34 PM
INDIRECT.EXT reference	pdabill	Excel Discussion (Misc queries)	1	August 25th 06 12:28 AM
Indirect reference (again?)	Hundikoer	Excel Worksheet Functions	6	October 25th 05 05:12 PM
indirect reference	BorisS	Excel Worksheet Functions	3	June 15th 05 03:40 PM
INDIRECT reference	saturnin02	Excel Programming	2	July 21st 03 02:51 AM

All times are GMT +1. The time now is 02:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us