Excel formula????

[99mel]

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. <br>
<br>
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<br>
<br>
Can anyone help?<br>
<br>
Thank u

 

[Lehtoant]

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