Summing multiple tabs

Question

Hi All,

I am trying to sum multiple tabs into one tab (I've attached some sample data to give you an idea of what I mean). Each of the tabs have the same layout, but I need the figures from each tab to sum together, so that I can get the total figure for the week. I assume that the start would be to import as sheet names, but not sure where to take it from there, so any help would be appreciated!

Cheers,

Peter.

Sales Example.xlsx

afv2688 · Answer

Hello @peterg97 ,

I think this time I managed to get what you want. This time it also does something else, if you add or there are some more columns added in the future the workflow will be able to add them automatically due the transpose tools 🙂

Regards

sum_sheets.yxmd

Qiu · Answer

@peterg97

Just a thought.

0205-peterg97.yxmd

peterg97 · Answer

Hi @afv2688,

Thanks for helping out! I hope you don't mind, but it's actually a bit more complicated than that, so any further help would be great! I've attached an updated excel file with a few more complications. Basically I only want to sum the tabs with (Overtime). What I have done for this is input as list of sheet names and then filter for contains 'Overtime' so i'm good up until it comes to the stage after the formula where it creates the full file path. Its the stage after that that i'm struggling with.

No problem if you can't take it any further, really appreciate the help up to this stage, its been useful!

Thanks,

Peter.

Sales Example.xlsx