LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 164
Default Calculate Number Attending

The spread sheet has 2000 plus names and addresses. Not all people will be
attending the event.
Col H = the state/prov, Col Q contains the number of people in that row
attending Is it possible to have in another sheet named totals for example a
list of all the states and provinces in one column, and in the next column
display the total number of people from that state/prov attending the function?

--

Regards
Michael Koerner



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate number of days Linda P. Excel Worksheet Functions 7 April 27th 10 04:29 PM
How to calculate number of occurencies of a specific number number Stefan Excel Discussion (Misc queries) 4 September 8th 08 08:33 AM
Calculate Number [email protected] Excel Discussion (Misc queries) 7 August 1st 07 03:56 PM
How to Calculate an unknown number? Beau Excel Worksheet Functions 1 May 28th 05 01:20 AM
calculate number of years D L Barnard New Users to Excel 1 January 26th 05 12:19 AM


All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"