Excel formula????

99mel · Jan 25, 2000

I am wondering how to find out how many rows I have got on sheet1. I am importing data. Just loads of numbers lets say but theres going to be different amounts of rows. 
 
I want on Sheet2 to have a formula which can find out how many rows are filled with data and do a simple calulation with all the rows (row 1 to row?) ?-This is what i want to know 
 
Can anyone help? 
 
Thank u

Lehtoant · Jan 25, 2000

You get the number of rows on Sheet2 with: 
=COUNT(Sheet1!A:A) for numerical column 
=COUNT(Sheet1!A:A) for text and numerical columns 
 
and sums as well...=SUM(Sheet1!A:A) 
 
If your data has a title row just add -1 to formula. 
 
Al

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Excel formula????

99mel

Programmer

Lehtoant

MIS

Similar threads

Part and Inventory Search

Sponsor