Forum Discussion
How to return counts of text cells across multiple worksheets in same workbook?
Without access to GROUPBY and PIVOTBY that can make short work of this task, your best bet may be to load the tables into PowerQuery, combine, and create pivots:
I typically prefer using formulas for a task like this but the summarization can get a bit messy without a full complement of functions available.
I've attached the workbook with the pivots.
This is what I was trying to do at the beginning. Very much looks like it will work for me, although my initial attempts failed. I will certainly give this a try and let you know how it works out. OliverScheurich also offered a formula-based solution below which I'm exploring. Thanks for the Power Query support document as well. Your assistance is greatly appreciated!
Glad I could help. You're welcome!