Summing tables across multiple tabs

Hello All,

I am trying to sum a table across multiple tabs. I have attached an example dataset below. The table below is present in every tab:

I want to sum this table for all the tabs where the tab name includes the word 'Overtime'. I know that I need to input the file as a list of names and then filter for the word 'Overtime' and then use a formula to get the file paths, but I don't know where to go from there. Is there a function that can do this easily?

Any help is greatly appreciated!

Cheers,

Peter

Sales Example.xlsx

Workflow

Datasets

Developer

Custom Tools

Dynamic Processing

Accepted answers

afv2688

Hello @peterg97 ,

I transformed it to you to 2019.1 version.

Hope is good now for you 🙂

If you need to change it further just open it with notepad++. On the first lines you will see the current version of the workflow. Change it manually to one that suits your needs and done.

You need to do this to both, the workflow and the macro.

Regards

Sum.yxzp

messi007

@peterg97,

that's how you do the downgrade

1- Open the yxmd with note pad

2 update the version

==> have done the downgrade for you to 2020.1you have to open workflow (SUM.yxmd)

be sure to save both .yxmd and .yxmc macro under the same folder.

Regards,

ReadFiles.yxmc

Sum.yxmd

All comments

messi007

@peterg97,

Please see below:

Attached the workflow,

Hope this helps,

Sum.yxzp

peterg97

Hi @messi007,

Thanks for the reply! Unfortunately, this is using a newer version of alteryx so I cant open the workflow. Do you know a way I could open it? Or could you attach some pictures of the inner workings if that's not too much effort?

Thanks for the help, really appreciate it!

Cheers,

Peter

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335