desparately need help

silvertree

New Member
Joined
Oct 16, 2006
Messages
6
I've selected a cell range, say A1:A10

now I want to move the entire range down 10 cells, so the new range will be from A11:A20.

can I do this using a formula?

thank u so much!!!!!!!!!
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
Hi -
Welcome to the board. position the cursor outside the selected range and when the cursor turn to arrow, left click then drag to the specified range.
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi Silvertree

Welcome to the Board!

I'm not sure I follow you, but you can use Cut & Paste to move the cells elsewhere. You could use formulas to reference the existing range, but the range would still subsequently exist in A1:A10, with duplicate values resulting from the reference in A11:A20.

Perhaps you can explain in more detail exactly what you are trying to do?

Best regards

Richard
 

silvertree

New Member
Joined
Oct 16, 2006
Messages
6
Sorry, I didn't explain it clearly.

I have lots of data so I cannot do that manually to all the data.

Actually I want to sum the values A1:A10 then I want to sum values in A11:A20 then sum values in A21:A30 and so on and so on...

Is there a way I can move the range down 10 cells every time?

How can I do that?
 

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624

ADVERTISEMENT

then where would you want to put the sum
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Well, you could use the following formula in an adjacent free column:

=SUM(OFFSET($A$1:$A$10,(ROW()-1)*10,0))

enter this in the first row eg B1 or C1 or D1 and copy down.

Richard

PS You may find pivot tables to be of use depending on your specific situation.
 

Forum statistics

Threads
1,136,347
Messages
5,675,235
Members
419,555
Latest member
Paddington

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top