Usage of count( ) function in excel

Closed
Neethi - Aug 7, 2010 at 10:13 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 7, 2010 at 07:29 PM
Hello,

how to use count function to display the no. of values from the sheet of one workbook onto the sheet of another workbook

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 7, 2010 at 07:29 PM
some thing like this

=COUNT('C:\Users\haadi\Desktop\preh\[PrehMenu.xls]Sheet2'!$B$1:$B$65536)
1