Drag Formula that skips every 12 Rows
I am trying to create some formulas that when they are pulled down to copy they skip 12 rows of data. For instance I am trying to sum the data from cells AD1462:AD1473 to Q1462. Then in Q1463 I want the sum of cells AD1474:AD1485. I wouldn't mind putting this in but I have almost 10000 rows to sum.
I have tried looking at other similar questions and have tried to use INDIRECT but failed to get a working formula.
Any help would be appreciated!
Try This -
In Q1462, Put =SUM(AD1462:AD1473) and hit enter.
Then Select Q1451:Q1462 (This makes it a Selection of 12 Cells with 11 Blank Cells and 1 cell with Sum Formula)
And now with the Range of 12 Cells selected, Just Drag Down using the Autofill option.
Hope this helps.
Cheers!
Deep
Cheers!
Deep Dave
That worked to a point. I need the cells that have the totals to be one after another. Instead of spaced 11 cells apart. Thanks for the response though.
Are you fine with a VBA Solution?
Of course!
Here!
Please try the file attached.
Are you looking for something of that sort?
Deep
In Q1462 Cell
Formula:
Please Login or Register to view this content.
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
@
Amazing Solution.
Learned something new..
Cheers!
Deep
Glad it helps you and thanks for the kind words
Great..............
Rgd
RT
If my answer(s) helped you, please add me reputation by click on *
Thanks, sixthsense. That's good for me, too!
Thanks
I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks