How to count number of rows in an excelsheet

Hello,
How to count number of rows filled with data in an excelsheet?
RIASAsked:
Who is Participating?
 
Ryan ChongConnect With a Mentor Commented:
where do i actually add
=COUNTA(A1:A1000)
just make it as an Excel formula...
28967719.xlsx
0
 
Ryan ChongCommented:
check this out:

Find last row, column or last cell
http://www.rondebruin.nl/win/s9/win005.htm
0
 
RIASAuthor Commented:
Ryan Chong,
Thanks ,how do i get it by excel formula in the excel worksheet?
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
Ryan ChongCommented:
>>how do i get it by excel formula in the excel worksheet?
sorry, i could be missunderstood your question.

to do it in excel, just use COUNTA function, like:
=COUNTA(A1:A1000)

Open in new window

0
 
RIASAuthor Commented:
where do i actually add
=COUNTA(A1:A1000)
0
 
RIASAuthor Commented:
Brilliant mate!!Cheers!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.