| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count data in cells
If I enter the following into individual cells what formula do I use so it
recognizes it when I total the column? A1 v65.49 A2 v65.49 A3 v45.89 Total 3 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count data in cells
So you just want a count of the cells with information in them?
=COUNTA(A1:A3) -- Regards, Dave "dd" wrote: If I enter the following into individual cells what formula do I use so it recognizes it when I total the column? A1 v65.49 A2 v65.49 A3 v45.89 Total 3 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count data in cells
Yes, thank you so much. It worked.
"David Billigmeier" wrote: So you just want a count of the cells with information in them? =COUNTA(A1:A3) -- Regards, Dave "dd" wrote: If I enter the following into individual cells what formula do I use so it recognizes it when I total the column? A1 v65.49 A2 v65.49 A3 v45.89 Total 3 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count data in cells
=COUNTA(A:A)
HTH, Paul "dd" wrote in message ... If I enter the following into individual cells what formula do I use so it recognizes it when I total the column? A1 v65.49 A2 v65.49 A3 v45.89 Total 3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count all cells which have same data | Excel Discussion (Misc queries) | |||
| How to count all cells which have same data | Excel Discussion (Misc queries) | |||
| Count Only Empty Cells AFTER Cells with Data | Excel Worksheet Functions | |||
| Count data in cells | Excel Worksheet Functions | |||
| Count cells with data | New Users to Excel | |||
Linear Mode
