Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|