LinkBack URL
About LinkBacks
Hello. Can I drag this formula down a column but have it change references for each row down?
=SUM(D7:M7) then
=SUM(E8:N7) etc
Hello. Can I drag this formula down a column but have it change references for each row down?
=SUM(D7:M7) then
=SUM(E8:N7) etc
Formula:
Please Login or Register to view this content.
Last edited by mehmetcik; 02-18-2016 at 12:48 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Try this where you want the answer and fill down
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Yours populate D7:M7 ; E7:N7 ; F7:O7Originally Posted by newdoverman
Try this where you want the answer and fill down
Formula:Please Login or Register to view this content.
while OP requests D7:M7 ; E7:N8 ; F9:O9
It should be:
=OFFSET($D$7:$M$7,0,ROWS($1:1)-1,ROWS($1:1),10)
Quang PT
Sorry everyone I meant to request E7:N7, it's just a shifting set of 10 cells going down a row, staggering to the right.
@ Mehmetek. You're formula returned a # ref error.
@NewDoverman. This is what I was looking for. Thanks.
@newdoverman. Why do you do *1+0. Isn't that unnecessary?
The *1+0 is necessary. It is being used as a counter. The *1 is the incremental value and the +0 is the starting number.
Try this in a column (just to see how this works)
Enter this in B2 and fill down
Formula:Please Login or Register to view this content.
The result should be a column of values starting with 5 and increasing by 2 every row.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks