Usage of count( ) function in excel

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
some thing like this

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

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month