Notifications
Clear all
General Excel Questions & Answers
5
Posts
3
Users
0
Reactions
95
Views
Topic starter
I have a workbook attached with this post. Please go through it.
There are 3 sheets having month wise data .
What I would like to know is how you make totals of three tabs appear as one total in fourth tab as a grand total.
Posted : 04/06/2021 7:38 am
Aren't your three tabs the same information? Why would you want to total that?
Posted : 04/06/2021 3:34 pm
Topic starter
This is just a dummy workbook. Iam unable to share the actual file due to privacy reasons.
I wanted to know how I can obtain the total consumption rate of the three departments month wise.
Posted : 05/06/2021 2:00 am
Hi Hitesh,
Use Power Query to get the data from the separate sheets, then unpivot it and summarise it with a PivotTable.
Mynda
Posted : 05/06/2021 3:19 am
Here is an example of making each of your three sets of data a power query, then appending the three to make one.
This works great as long as all three data sets have the same column headings. From there you can make your formulas on the new appended sheet, or you can make a pivot table, etc.
Posted : 05/06/2021 8:05 am