Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Office

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-15-2005, 01:52 PM
Novice
 
Join Date: Jun 2005
Posts: 2
Rosie is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 06-15-2005, 02:04 PM
Matrix's Avatar
Matrix Matrix is offline Windows 7 32bit Office 2010 32bit
Admin
 
Join Date: Jan 2005
Posts: 468
Matrix is on a distinguished road
Default

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).
Reply With Quote
  #3  
Old 06-15-2005, 02:23 PM
Novice
 
Join Date: Jun 2005
Posts: 2
Rosie is on a distinguished road
Default

THANKS! Just that bit of help has done the very trick. It's =COUNT in Works.
Reply With Quote
  #4  
Old 06-15-2005, 02:27 PM
Matrix's Avatar
Matrix Matrix is offline Windows 7 32bit Office 2010 32bit
Admin
 
Join Date: Jan 2005
Posts: 468
Matrix is on a distinguished road
Default

Glad you figured it out.

BTW, welcome to the forums.
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 06:48 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft