This content has been marked as final.
Show 5 replies

1. Re: taking sum of calculated averages and subtracting value from different sheet
pavan hm Jan 21, 2019 1:32 AM (in response to Sourav Ghosh)
sample_book1.twbx 22.6 KB


2. Re: taking sum of calculated averages and subtracting value from different sheet
Sourav Ghosh Jan 21, 2019 1:43 AM (in response to pavan hm)hi Pavan,
the numbers are not matching with excel sheet 2.
Also can you share your workbook.
Thanks for your effort!
Sourav

3. Re: taking sum of calculated averages and subtracting value from different sheet
pavan hm Jan 21, 2019 10:29 PM (in response to Sourav Ghosh)Pls find the updated workbook.
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

sample_book1.twbx 25.0 KB


4. Re: taking sum of calculated averages and subtracting value from different sheet
Sourav Ghosh Jan 22, 2019 7:18 PM (in response to pavan hm)Hi Pavan,
That's correct.
Can you share the formula and logic how you have done it, thanks!

5. Re: taking sum of calculated averages and subtracting value from different sheet
pavan hm Jan 23, 2019 5:40 AM (in response to Sourav Ghosh)Hi saurav,
I have attached the workbook .you can see all logics and formulas .
Please mark it correct if it helped.