| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count cells with data
what formula will count cells that contain any randmon data
text number, just basicly it will return a count for a range of cell that are not empty |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count cells with data
Sounds like you want the COUNTA function...
=COUNTA(C3:D500) Just set the range reference as needed. -- Rick (MVP - Excel) " wrote in message ... what formula will count cells that contain any randmon data text number, just basicly it will return a count for a range of cell that are not empty |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count cells with data
nope, that counted the range.
I would like someithing that only counts the cells in the range that have data and does not count the empty cells "Rick Rothstein" wrote: Sounds like you want the COUNTA function... =COUNTA(C3:D500) Just set the range reference as needed. -- Rick (MVP - Excel) " wrote in message ... what formula will count cells that contain any randmon data text number, just basicly it will return a count for a range of cell that are not empty |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count cells with data
=COUNTA(range)
Explanations of different types of COUNT functions are in help. Gord Dibben MS Excel MVP On Tue, 27 Jan 2009 13:59:01 -0800, wrote: what formula will count cells that contain any randmon data text number, just basicly it will return a count for a range of cell that are not empty |
| 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
