ANSWERS: 1
-
I would use the countif function in each sheet within the workbook to count that word in each cell of that sheet. I would then summate that cell from each worksheet into a "cover" sheet for the workbook.
Copyright 2023, Wired Ivy, LLC