need help with a formula

[LJ]

I have a column that data will be entered in and I need to have a cell that
will increase numerically with the number of cells that have a number in it
in the column. for example there are five cells with data. the summary cell
should say 5 when I enter another cell of data the summary cell should change
to 6

 

[Lars-Åke Aspelin]

I have a column that data will be entered in and I need to have a cell that
will increase numerically with the number of cells that have a number in it
in the column. for example there are five cells with data. the summary cell
should say 5 when I enter another cell of data the summary cell should change
to 6

Have a look at the COUNT() and COUNTA() formulas.

Hope this helps / Lars-Åke

 

[Mike H]

Try

=COUNTA(A:A)

Mike

 

[Eduardo]

Hi,
in excel 2007 if the data is in column A

=COUNT(A:A)

If you don't have excel 2007 use

=COUNT(A1:A1000)

If this was helpful please say yes. thank you

 

[Ron Rosenfeld]

I have a column that data will be entered in and I need to have a cell that
will increase numerically with the number of cells that have a number in it
in the column. for example there are five cells with data. the summary cell
should say 5 when I enter another cell of data the summary cell should change
to 6

If the data is numeric:

=count(a:a)

If the data is textual:

=counta(a:a)

(Substitute your column to test for the a:a).
--ron

 

[Mike H]

eduardo

Count accepts full column arguments in 2003

Mike