Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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: 438
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
Reply



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 10:45 AM.


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