Counting Different Values

C

cassy01

Well here we go,

i have coloum B which has the name of the person and column F has the
number

now i want to have a summary page which has :

Name & Number from the other page counted up.

For Example:

Robert Smith 10
Robert Smith XX
Jim Smith 10
Jim Cox 10
Jim Cox XX
Jim Cox 10

and on the summary page it has:

Robert Smith - 10 Total: 1
Robert Smith - XX Total: 1
Jim Smith - 10 Total: 1
Jim Cox - 10 Total: 2
Jim Cox - XX Total:1

is this possible using formulas ???

Many Thanks
Benn
 
F

Frank Kabel

Hi
you could try the following:
1. Create a helper column (e.g. column C) with the formula
=A1 & " - " & B1

2. Now use a pivot table on this column
 
Top