Hi there
Could you please assist with a formula to sum multiple sheets into one summary sheet
I've attached a file as reference
I need a formula under Summary column: B:B to sum column: H:H under its specific sheet as per Products.
And under Summary column: F:F to sum column: O:O under sheet: ANGLES & CHANNELS respectively
I entered a formula in C1 on each sheet [ANGLES and CHANNELS] to figure out last ROW [where totals would be].
There may be a different or better way to figure out last row, but this one works.
Formulas used in Summary sheet:
In B6:
In F6:HTML Code:
See attached file.HTML Code:
1. Click on the * Add Reputation if you think this helped you
2. Mark your thread as SOLVED when question is resolved
Modytrane
Perfect it works thanks a lot
Can I ask something again on the same file please
Yes, but start a new thread with an appropriate title. Attach the workbook to the new thread.
Mark this thread as solved: select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks