| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
number of cells containing text
I am looking for a formula that sums the number of cells in a range that I
choose that are not blank (contain some text or date), for example assigning a value of 1 to each cell containing a name and then giving me the number of cells in that range that contains a name (also assume that every nonblank cell contains a name). I am looking to do this with a range (A1:A20) so that I can insert cells into that range and still have the formula calculate. Can someone please help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
number of cells containing text
You may use the formula COUNTA directly, that counts non blank cells in a
range: =COUNTA(A1:A20) Hope this helps, Miguel. "Xhawk57" wrote: I am looking for a formula that sums the number of cells in a range that I choose that are not blank (contain some text or date), for example assigning a value of 1 to each cell containing a name and then giving me the number of cells in that range that contains a name (also assume that every nonblank cell contains a name). I am looking to do this with a range (A1:A20) so that I can insert cells into that range and still have the formula calculate. Can someone please help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count the number of Excel cells with text formatted Italic | Excel Worksheet Functions | |||
| total cells with text and number EX: GS-5 | Excel Worksheet Functions | |||
| How do I sum text cells with number cells? | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
Hybrid Mode
