How to drag a formula to the right and skip x columns
Requirement:
The user would like to drag the formula to the right by picking the values from another sheets and sum its.
So, it should skip every 3 columns.
Solution:
=SUM(OFFSET(GMV!$E$1,0,(COLUMN()-1)*4):OFFSET(GMV!$E$11,0,(COLUMN()-1)*4))
paste in your first column "A" and then press the Enter key
Then drag it ...
if your formula column is not first "A" and minus the before column count from where you paste.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to skip VBA Code if table filter returns nothing |
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
