| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding text
Not sure if my question went through:
How do I add rows of text? example Pam Joe Bob sara Total: 4 -- keb |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
adding text
Hi, Karen,
Use the =COUNTA function. So, if your names are in cells a1:a4, =COUNTA(A1:A4) would return 4 You use =COUNT to count numeric values and =COUNTA to count non-numeric values in any given range. Hope this helps Pete "karen" wrote: Not sure if my question went through: How do I add rows of text? example Pam Joe Bob sara Total: 4 -- keb |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
adding text
Do you mean =Counta(A1:A4) in Cell A5?
"karen" wrote: Not sure if my question went through: How do I add rows of text? example Pam Joe Bob sara Total: 4 -- keb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding text | Excel Discussion (Misc queries) | |||
| Adding text to equal text | Excel Discussion (Misc queries) | |||
| Adding Dashes in front of text using text formating | Excel Discussion (Misc queries) | |||
| Adding text | Excel Worksheet Functions | |||
| Adding text | New Users to Excel | |||
Linear Mode
