Calculate Number Attending

Michael Koerner · 02-05-2005, 06:06 AM

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

**jindon** · 02-05-2005, 06:54 AM

Hi,
assuming you have a header in cell H1

Please Login or Register  to view this content.

hope this helps
jindon

Jim May · 02-05-2005, 10:06 AM

Check out Pivot Table (Menu, Data, Pivot Table) usage for this.

"Michael Koerner" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>

Michael Koerner · 02-05-2005, 11:06 AM

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" <[email protected]> wrote in message
news:3N3Nd.54961$jn.14660@lakeread06...
Check out Pivot Table (Menu, Data, Pivot Table) usage for this.

"Michael Koerner" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>

Debra Dalgleish · 02-05-2005, 11:06 AM

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

Michael Koerner · 02-05-2005, 12:06 PM

Thanks, will have a look.

--

Regards
Michael Koerner

"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
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

Michael Koerner · 02-05-2005, 02:06 PM

Instructions were great, works like a charm. Thanks to all.

--

Regards
Michael Koerner

"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
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