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
|