Calculate Number Attending

  • Thread starter Thread starter Michael Koerner
  • Start date Start date
M

Michael Koerner

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?
 
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


Check out Pivot Table (Menu, Data, Pivot Table) usage for this.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine two spreadsheets into one 3
Excel VBA assistance 4
Debugging Loop script 2
Output list based on value in a cell 2
Last Occurance 12
Button Programming 2
I can't seem to find anything with regards to this.. sorry 3
help with a worksheet needed 3

Back
Top