| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count if cell if fill with text
if a cell is fill up with text it is consider one count. what is the formula
to use? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count if cell if fill with text
=COUNTA(A1:A25)
Regards Trevor " wrote in message ... if a cell is fill up with text it is consider one count. what is the formula to use? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count if cell if fill with text
COUNTA will count *all* non-empty cells. Both TEXT and NUMBERS.
To count *only* cells that contain TEXT (this includes formula blanks): =COUNTIF(A1:A10,"*") Biff " wrote in message ... if a cell is fill up with text it is consider one count. what is the formula to use? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| quick ? on how to auto fill text from one cell to another | Excel Discussion (Misc queries) | |||
| weird no more cell fill and text colour | Excel Discussion (Misc queries) | |||
| I cannot add fill colour to any cell, or use coloured text | Excel Worksheet Functions | |||
| How to auto-fill text based on text in another cell | Excel Discussion (Misc queries) | |||
| HOW CAN I AUTO FILL A CELL WITH TEXT FROM ANOTHER WORKSHEET TEXT . | Excel Worksheet Functions | |||
Hybrid Mode
