Data--Pivot Table

Follow the instructions in the wizard.

I don't have any links offhand but googling pivot table will likely yield
some good documentation.

Dave

"jiwolf" wrote:

try a pivot table


"Jim W" <Jim wrote in message
...
Trying to create an excel chart to create totals based upon different
keys. I
need to be able to calculate how many customers there are by Manager and
then
By Rep. Then to figure out how many were New, Current, Total # of RSVP and
attended for that Rep. Below is how I have started but I am having some
problems getting certain parts. I know when I get one the rest will fall
into
place. I can calculate how many total customers by manager and by rep just
by
doing a Countif command but how do I determine the # of New, Current etc.
Is
there a If Than command? Managers Totals are simply his reps totals.
Suggestions?

Example..
A B C D E
F G
1 Manager Rep Customer New Biz Current # RSVP # Actual
Attend

Need totals to look something like this....

A B C D E
F G
1 # of Cust # New # Current #RSVP #
Actual Attend
2 Manager
3 Rep 1
4 Rep 2