Row Count

katie · Mar 18, 2009

I want to set a formula to count the number of items a column has. The cells
in the column contain number though....Any thoughts??? Please help me

Gary''s Student · Mar 18, 2009

=COUNTA(A:A)
or
=COUNT(A:A)

David Biddulph · Mar 18, 2009

=COUNTA(A:A)
or, if you only want to count cells with numbers, =COUNT(A:A)

katie · Mar 18, 2009

Thanks so much that was perfect

Gary''s Student said:
=COUNTA(A:A)
or
=COUNT(A:A)

Counting results of a formula	9	May 4, 2010
count nonblank cells	3	Mar 13, 2010
How to count merged cells	1	Apr 9, 2010
Count number of rows with specific text	2	May 24, 2010
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel.	1	Nov 7, 2014
Sumproduct & Count formula	8	Dec 5, 2008
Count rows based on multiple criteria	3	Feb 4, 2010
COUNTIF for 2 columns	6	Mar 25, 2010

Ask a Question