Counting number of row entries
 

I have an excel file with entries in table format. I want excel to count how
many rows are in that information table.

The 1st column of the table is an incrementing number.

Maybe one way is for Excel to detect the presence of an entry in the cell &
count the no. of cells which has an €˜x for example?

Is this possible?

Bob.

Counting number of row entries
 

You could use:

=counta(a:a)
to count all the entries in column A.

If you (always!) have headers in column A:
=counta(A:a)-1

BobD wrote:

I have an excel file with entries in table format. I want excel to count how
many rows are in that information table.

The 1st column of the table is an incrementing number.

Maybe one way is for Excel to detect the presence of an entry in the cell &
count the no. of cells which has an €˜x for example?

Is this possible?

Bob.

--

Dave Peterson