Forum

Notifications
Clear all

How to get cumulative total of three spreadsheets into one sheet as grand total

5 Posts
3 Users
0 Reactions
95 Views
(@hitesh222002)
Posts: 7
Active Member
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
(@ejbiker93ss)
Posts: 2
New Member
 

Aren't your three tabs the same information? Why would you want to total that?

 
Posted : 04/06/2021 3:34 pm
(@hitesh222002)
Posts: 7
Active Member
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
(@mynda)
Posts: 4761
Member Admin
 

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
(@ejbiker93ss)
Posts: 2
New Member
 

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
Share: