• 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

Answerbag | Terms of Service | Privacy Policy