Excel formula????
Excel formula????
(OP)
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
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
RE: Excel formula????
=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