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

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

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

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

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

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