How to Count / COUNTIF Items Across Multiple Worksheets in Excel

Microsoft Excel Tips and Tricks

The method I demonstrate requires you to house all your data in Excel tables and then to name those tables. You can then refer to the table names with the INDIRECT function to return multiple ranges in one formula.

Credit Chester Tugwell