need help with a formula
 

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

need help with a formula
 

On Wed, 18 Feb 2009 12:12:05 -0800, LJ
wrote:

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

need help with a formula
 

Try

=COUNTA(A:A)

Mike

"LJ" wrote:

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

need help with a formula
 

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

"LJ" wrote:

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

need help with a formula
 

On Wed, 18 Feb 2009 12:12:05 -0800, LJ wrote:

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

need help with a formula
 

eduardo

Count accepts full column arguments in 2003

Mike

"Eduardo" wrote:

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

"LJ" wrote:

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