Excel Workbook totals
 

I am looking for a way to count all the rows across all sheets in a workbook.

Example: each sheet contain a list of phone numbers and I would like to know
how many are in the workbook.

There are 60+ sheets, each has a different number of rows.

Excel Workbook totals
 

Let's say phone numbers stored in Column E of all sheets

on the sheet 1
=COUNTA(Sheet1:Sheet3!E:E)



"Robert" wrote:

I am looking for a way to count all the rows across all sheets in a workbook.

Example: each sheet contain a list of phone numbers and I would like to know
how many are in the workbook.

There are 60+ sheets, each has a different number of rows.