| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding text
hello - I am trying to total the number of rows I have - how do I do that
with Text in it? Example John Sara Kim Pam Total: 4 -- keb |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
adding text
Use COUNTA(range).
Hope this helps. Pete On Aug 13, 3:44*pm, karen wrote: hello *- I am trying to total the number of rows I have *- how do I do that with Text in it? Example John Sara Kim Pam Total: *4 -- keb |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
adding text
=COUNTA(A1:A6)
John (A1) Sara (A2) Kim (A3) Pam (A4) dek (A5) Paul (A6) hope this helps "karen" wrote in message ... hello - I am trying to total the number of rows I have - how do I do that with Text in it? Example John Sara Kim Pam Total: 4 -- keb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | Excel Discussion (Misc queries) | |||
| Adding text | New Users to Excel | |||
Linear Mode
