I have a workbook that contains more than 67 sheets of same formats and columns. Now, in a new sheet in the same workbook, I want to count the cells of Column B of all sheets separately, for example:
Column B of Nepal - 456 Cells
Column B of Pak - 1245 Cells
Column B of CHN - 981 Cells
Column B of UK - 1027 Cells
Column B of USA - 789 Cells
& so on
I would like to have a common formula to link the all sheets instead of clicking each sheet one by one using =CountA(Nepal!B:B) and so on. I tried it listing all sheet names in a new sheet and applying formula to its corresponding cell. It took long time and tedious job to click again and again. So please suggest me a formula so that I can do it in easy way.
Bookmarks