Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-15-2005, 01:52 PM
Rosie Rosie is offline
Novice
Spreadsheet for words
 
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 Spreadsheet for words Windows 10 Spreadsheet for words Office 2010
Admin
 
Join Date: Jan 2005
Posts: 429
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
Rosie Rosie is offline
Novice
Spreadsheet for words
 
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 Spreadsheet for words Windows 10 Spreadsheet for words Office 2010
Admin
 
Join Date: Jan 2005
Posts: 429
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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft