| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cells that contain data
Hi,
I'm trying to use the count function to count the number of cells in a range of cells which contain data. I can't figure out how to do it, can anyone help. Thanks Karl |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells that contain data
=COUNTA(range)
COUNT only counts numerics. Gord Dibben MS Excel MVP On Fri, 13 Oct 2006 16:56:01 -0700, Karl wrote: Hi, I'm trying to use the count function to count the number of cells in a range of cells which contain data. I can't figure out how to do it, can anyone help. Thanks Karl |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells that contain data
=COUNT(A1:A100)
"Karl" wrote: Hi, I'm trying to use the count function to count the number of cells in a range of cells which contain data. I can't figure out how to do it, can anyone help. Thanks Karl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Only Empty Cells AFTER Cells with Data | Excel Worksheet Functions | |||
| Selecting data from different cells for a chart | Charts and Charting in Excel | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Counting cells with data | Excel Discussion (Misc queries) | |||
Linear Mode
