#1
|
|||
|
|||
Spreadsheet for words
Hello. I want to add words together instead of numbers, ie. I have lists of names that will keep changing and I want to keep track of numbers of people....Does anyone know if such a thing exists? Can I do it using a Works spreadsheet or does that only tackle data? Godany ideas?
Thanks |
#2
|
||||
|
||||
Not sure about Works, but this can be done easily in Excel. Suppose you have a column (A) for people, assign any cell with the following formula to calculate the numbers of people:
=COUNTA(A1:A1000) (A1000 is just a random number, you can use any other one as long as it's bigger than the number of people). |
#3
|
|||
|
|||
THANKS! Just that bit of help has done the very trick. It's =COUNT in Works.
|
#4
|
||||
|
||||
Glad you figured it out.
BTW, welcome to the forums. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cell Comments in a Protected spreadsheet | dmgerber | Excel | 1 | 06-06-2010 05:10 AM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |
Hyperlinking pdf file into spreadsheet | mygoat | Excel | 0 | 05-09-2006 11:59 PM |
Counting Legal Words | bulletrick | Word | 0 | 12-30-2005 03:22 AM |