Counting Different Values

[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

 

[icestationzbra]

check out this link, see if it helps your cause. debra's site has a lo
to offer in terms of info on filters.

http://www.contextures.com/xladvfilter01.html#FilterU

 

[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