Count Categories in multiple sheets

[ynwkm]

Hi, I'm trying to have counts of categories within a workbook across multiple sheets.

I want to input "Example_Category.xlsx" and "Example_SearchWorkbook.xlsx", and get an output of "Example_WantedResult.xlsx".

Thank you in advance!

[fmvizcaino · Accepted solution]

Hi @ynwkm ,

Attached is an example showing how to do it.

In order to work, please leave the input files in the same folder as your workflow.

Best,

Fernando Vizcaino

[DavidP]

Something like this?

[ynwkm]

@DavidP Exactly like that, but I want to input the category file as well in order to make future workflow more streamlined.

[ynwkm]

This is amazing, can you give me an explanation why the files need to be in the same location?

Thank you so much for this!