Sum - offset

R

Romos1_excel

New Member
Joined
Apr 5, 2018
Messages
7
Hello everyone!

I run the rum - offset - row formula for the values in a column to sum every other 10 rows and when I drag the formula down (vertically) it works.
When I drag the formula horizontally it keeps summing only the first 10 rows of the selected area. Any ideas how to make it work when I drag it horizontally ? ?
Picture attached as link

Many thanks!

https://drive.google.com/file/d/1UcoWomLdIxcxsz7vhaDluUa2pdbWMLNy/view?usp=sharing
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Sort by date Sort by votes
In B4 like
=SUM(OFFSET($K$5,(COLUMN()-2)*10,0,10,1))
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
OFFSET dragging horizontally
2
Replies
10
Views
312
Muhammad_Usman
Muhammad_Usman
C
  • Question
Excel formula to dynamically reference a range using values from a horizontally and vertically spilled ranges
Replies
1
Views
555
cadams1979
C
A
  • Question
Solver Optimization Tool
Replies
1
Views
90
Eric W
Eric W
B
  • Question
cant drag the conditional formating rules formulas in column side, but i can do it in row wise
Replies
1
Views
151
awoohaw
awoohaw
A
  • Question
OFFSET Drag down not working as intended
Replies
2
Views
206
Atlantir
A

Forum statistics

Threads
1,215,453
Messages
6,124,929
Members
449,195
Latest member
Stevenciu

Share this page

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
Back
Top