how to count number in the sheet
Answers
Answered by
1
which sheet??????? ???
Vaibhav1803:
spreadsheet
Answered by
2
✭ This method works in 2003 and 2007 version
1. Click ''Ctrl+F3',
then 'Define Name' Box appears
2. Enter 'Names in workbook' as CountSheets(Your choice)
3. Enter 'Refers To' as =GET.WORKBOOK(1)&T(NOW())
4. Click OK
5. Come to the Cell, where you want to enter the Formula
6. Enter the Formula as =COUNTA(INDEX(CountSheets,0))
7. Click Enter
1. Click ''Ctrl+F3',
then 'Define Name' Box appears
2. Enter 'Names in workbook' as CountSheets(Your choice)
3. Enter 'Refers To' as =GET.WORKBOOK(1)&T(NOW())
4. Click OK
5. Come to the Cell, where you want to enter the Formula
6. Enter the Formula as =COUNTA(INDEX(CountSheets,0))
7. Click Enter
Similar questions