Need a count of *every* entry in a workbook

Дата публикации: 31-01-2020 17:01:08

So I'm using Excel to create the framework for a catalog of a glass slide collection. One spreadsheet alone has nearly a hundred tabs, all named uniquely with an abbreviation of the slide name, each tab having from 1 to over 100 entries. Is there any formula (I'm fine with macros!) that could tell me how many entries are in each workbook, excluding the header row on each page? Maybe one that could count the total number of ID field entries? This would be VERY useful, because I stopped counting manually after 12,000 entries. I've included the smallest file below, for testing purposes. Thanks!

Схожие новости

#	Наименование новости	Тональность	Информативность	Дата публикации
1	Smilegate Having Another Go With Another Crossfire Game	0	7.17	05-06-2026

Классификация: . Схожих патентов: 0. Схожая новость: 1. Тональность: 0. Информативность: 0. Источник: techcommunity.microsoft.com.