Hi,
I have workbook with 10 worksheet (Day1,Day2,Day3.....Day9,Day10) and 1 Sheet "Summary".
I need formula which Multiply two columns and then sum in "Summary" Sheet based on multiple sheet in the same column.
Thanks.
Hi,
I have workbook with 10 worksheet (Day1,Day2,Day3.....Day9,Day10) and 1 Sheet "Summary".
I need formula which Multiply two columns and then sum in "Summary" Sheet based on multiple sheet in the same column.
Thanks.
My English is very poor, so please be patient >_<"
Thanks & Regards.
hkbhansali
I feel that the multiplication could be done in each "Day" sheet individually then the sum calculated on the "Summary" sheet.
It may help if you attach a sample workbook as per the instructions in the banner at the top of the page.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Have you considered keeping all your daily data on a single sheet with an extra column to identify the day?
It seems to me that would be a lot more flexible and simplify any analysis, and of course you open up the stnadard Pivot Table functionality
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks