| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate Number Attending
Check out Pivot Table (Menu, Data, Pivot Table) usage for this.
"Michael Koerner" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate Number Attending
Jim, thanks I have never used a Pivot Table before. Any place to go where I can
see an example on setting one up? -- Regards Michael Koerner "Jim May" wrote in message news:3N3Nd.54961$jn.14660@lakeread06... Check out Pivot Table (Menu, Data, Pivot Table) usage for this. "Michael Koerner" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate Number Attending
There are instructions and links for pivot tables on Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivotstart.htm Michael Koerner wrote: Jim, thanks I have never used a Pivot Table before. Any place to go where I can see an example on setting one up? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate Number Attending
Thanks, will have a look.
-- Regards Michael Koerner "Debra Dalgleish" wrote in message ... There are instructions and links for pivot tables on Jon Peltier's site: http://peltiertech.com/Excel/Pivots/pivotstart.htm Michael Koerner wrote: Jim, thanks I have never used a Pivot Table before. Any place to go where I can see an example on setting one up? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate Number Attending
Instructions were great, works like a charm. Thanks to all.
-- Regards Michael Koerner "Debra Dalgleish" wrote in message ... There are instructions and links for pivot tables on Jon Peltier's site: http://peltiertech.com/Excel/Pivots/pivotstart.htm Michael Koerner wrote: Jim, thanks I have never used a Pivot Table before. Any place to go where I can see an example on setting one up? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate number of days | Excel Worksheet Functions | |||
| How to calculate number of occurencies of a specific number number | Excel Discussion (Misc queries) | |||
| Calculate Number | Excel Discussion (Misc queries) | |||
| How to Calculate an unknown number? | Excel Worksheet Functions | |||
| calculate number of years | New Users to Excel | |||
Hybrid Mode
