Thank you for your reply,
I've done as requested.
I've uploaded the workbook as attachment schedule.xlsx
The highlighted area in yellow is where I need results with some intructions.
I have manually entered the results expected in the top area. Thanks!
Hi,
Would you check the attached, rows 36 & 37. I get a different answer in M37 to your M16 example.
I've only added the two rows at the moment. If however the calculations are correct then it would be better to improve the formula by including an Offset function so that a common formula could be used and copied everywhere. As it is at the moment because two detail rows are required in the summary, summary formula in one row can't be copied to the row immediately below since the detail rows that need to be use are in pairs which are offset by two positions each time
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Very good. This is exactly what I needed.
I'll work on getting the offset done correctly.
I appreciate you help, thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks