Posted to microsoft.public.excel.misc

Sasikiran

external usenet poster

Posts: 104

Dragging a formula

Dear,

I need to drag the formula in a column in such a way that the formula should
proceed in this manner.

SUM(B14:B18)
SUM(B62:B68)
SUM(B110:B114)

it should calculate the sum range of 4 continuos cells after every 48th
cell...

Hope this is clear

Please suggest

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
Dragging a formula	saltnsnails	Excel Discussion (Misc queries)	2	January 13th 09 04:49 PM
dragging my formula	rodchar	Excel Discussion (Misc queries)	0	July 22nd 08 12:38 AM
Dragging Down a Formula	JBoyer	Excel Worksheet Functions	4	July 3rd 08 12:57 PM
Dragging formula	Sasikiran	Excel Discussion (Misc queries)	8	November 15th 07 11:01 PM
dragging a formula	P Bates	Excel Discussion (Misc queries)	3	August 7th 05 09:37 PM

All times are GMT +1. The time now is 10:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us