offset formula question

[ariel20029]

Hi,
I have a data set where the number of rows change when the data is refreshed. I am trying to count the number of rows in the population ( not including blanks)..

I am tired of manually having to update the last cell of the range in the formula every time I refresh. I have dozens of spreadsheets where I have to update formula to get the population.

Data starts on column E25


Column E
5%
8%
(blank)
7%

Right now my formula is =offset(E25:E5000)-1,0)
I entered as an array ( not sure if it needs to be or not)

the minus one is to subtract the total. For some reason I am getting an answer with the count of 1.. can you please help.. I tried an count A formula and that did not work either.


thanks,
Sharon

 

[Eric W]

If you just want to count the number of cells with numbers in them:

Book1
	D	E
1		Header
2	3	5%
3		8%
4
5		7%
6
Sheet5

Cell Formulas
Range	Formula
D2	=COUNT(E:E)

Subtract 1 if there's a total line, but I don't see why you'd want to total up percentages.