Getting a count of the number of worksheets in a spreadsheet

Getting a count of the number of worksheets in a spreadsheet

August 11, 2016

Follow the instructions on this site, in order to get a count of the number of worksheets in a spreadsheet.   

 

Go to  Formulas tab and in the 'Defined Names' section select 'Define Name'

 

 

In the dialog box that appears use the name 'countsheets' and then enter the formula =GET.WORKBOOK(1)&T(NOW()) in the 'Refers to' box. 

 

 

 

Now you can just enter the formula, =COUNTA(INDEX(countsheets,0))  to get a sheet count.

 

 

 

 

 

 

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com