LinkBack URL
About LinkBacks
What I want:
(example)
Total of A1:D1 on Sheet2's A1
Total of E1:H1 on Sheet2's B1
Total of I1:L1 on Sheet2's C1
Total of M1:P1 on Sheet2's D1
.. and so on.....
I think here "offset" function will work but not sure, how?
What I want:
(example)
Total of A1:D1 on Sheet2's A1
Total of E1:H1 on Sheet2's B1
Total of I1:L1 on Sheet2's C1
Total of M1:P1 on Sheet2's D1
.. and so on.....
I think here "offset" function will work but not sure, how?
Last edited by sajidbeg; 07-22-2016 at 10:33 AM. Reason: Using proper word! (adjacently)
Hi, welcome to the forum
There may be a better to do this, can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
incremental formula.png
I don't know how to upload 'workbook'
On Sheet2!A1 enter
=SUM(Sheet1!A1:D1)
On Sheet2!B1 enter this and fill across
=SUM(OFFSET(Sheet1!$A$1,0,0,1,COLUMNS((Sheet1!$A$1:B1)-1)*4+0))-SUM(OFFSET(Sheet1!$A$1,0,0,1,COLUMNS((Sheet1!$A$1:A1)-1)*4+0))
<---------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
Here is something much better than the first formulae that I first gave you.
Enter in Sheet2!A1 and fill across.
Formula:
Please Login or Register to view this content.
That's so brilliant, newdoverman! Thank you very much!
Additional help needed. Okay, it's working just toward right sided cells, fine! but how it could be possible if I need to fill the down cells? Sum blocks of 4.xlsx
This should do it.
Formula:Please Login or Register to view this content.
Yes! It's perfect. Thanks a lot.
Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks