| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the countA function is counting everything even empty cells
I have an Excel spreadsheet with 8000 rows. I would like to know how many
cells in a particular column have value or text entered. When I use the formula =countA(e5:e8003), the number returned is 7998 (the number of rows in the column). As I eyeball the document, obviously not every cell has a number or text in it, though. Shouldn't this formula only count the cells in that range that do have text or a number? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
the countA function is counting everything even empty cells
Try: =COUNTA(e5:e8003)-countblank(e5:e8003) and you're golden.
Dave -- Brevity is the soul of wit. "ToniNolen" wrote: I have an Excel spreadsheet with 8000 rows. I would like to know how many cells in a particular column have value or text entered. When I use the formula =countA(e5:e8003), the number returned is 7998 (the number of rows in the column). As I eyeball the document, obviously not every cell has a number or text in it, though. Shouldn't this formula only count the cells in that range that do have text or a number? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
the countA function is counting everything even empty cells
That did it--Thank you very much. TN
"Dave F" wrote: Try: =COUNTA(e5:e8003)-countblank(e5:e8003) and you're golden. Dave -- Brevity is the soul of wit. "ToniNolen" wrote: I have an Excel spreadsheet with 8000 rows. I would like to know how many cells in a particular column have value or text entered. When I use the formula =countA(e5:e8003), the number returned is 7998 (the number of rows in the column). As I eyeball the document, obviously not every cell has a number or text in it, though. Shouldn't this formula only count the cells in that range that do have text or a number? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Linear Mode
