Bram

Posts: n/a

how can I drag formulas with other cell references

example
cell A1 contains formula "=stdev(a2:a7)
cell a2 contains formula "=stdev(a8:a13)
Is it possible to drag the formula down so that cell a3 contains
"=stdev(a14:19) and cell a4 contains "=stdev(a20:a25) and so on for cells a5,
a6, a7 etc. etc.

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
Excel insits that I use absolute cell references	Espen	Excel Discussion (Misc queries)	6	January 5th 17 05:47 AM
Cell References	gman	Excel Discussion (Misc queries)	2	September 9th 05 05:56 PM
Formulas within Cell References	jhockstr	Excel Discussion (Misc queries)	4	August 13th 05 06:40 AM
Sumif function with remote cell references	hennis	Excel Worksheet Functions	1	August 12th 05 01:54 AM
Absolute cell references and subsequent problems.	Pank Mehta	Excel Discussion (Misc queries)	2	April 19th 05 11:38 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us