How to count the specific data from the first sheet until last sheet (or unlimited sheets if possible) in a workbook.
For example I want to calculate the 'BINGO' word in all sheets.
I've tried using COUNT,SUBTOTAL,INDIRECT and SUMPRODUCT, but it only able to count from 1 sheet only.
Bookmarks