Count the total number of rows in a column, with blanks included

**jblumGRT** · 10-12-2009, 01:46 PM

Ok I feel like this is probably a fairly easy thing to do, but every way that I try it I'm not getting correct answers so I've decided to suck it up and beg for help from a higher power....

What I have is a spreadsheet where columns represent a particular solid reactant (i work in a chem research company) and the rows are the "cycle number" of that solid. So for example, maybe the first 6 rows of the column will have actual numbers in them, but then anywhere from 2-100 rows will be blank until I start collecting data on the solid again, then I have more cells with data then more blanks and so on and so forth. What I need is a function that will count the total number of cycles I have for that column; so it needs to find the last row in that column that contains a number but then count the total rows from that one all the way up to the heading, including all the blanks. The number in the last row is not necessarily going to be a min or max or the data set, it could technically be just about anything.

Any help with this would be awesome, thanks so much!!!

Jen

**DonkeyOte** · 10-12-2009, 02:09 PM

If always numeric the below

=MATCH(9.99999999999999E+307,A:A)

would return the row number of the last row containing a number in Column A ... subtract from that the row of the header to give row count.