Try this:

Your raw data list is in Sheet2

Enter this formula in B2 of your summary sheet:

=SUMPRODUCT(--(Sheet2!$A$1:$A$7=$A2),--(Sheet2!$B$1:$B$7=B$1))

Copy across then down as needed.

Biff

"Greg C" <Greg wrote in message
...
I would like to have a summary table set up like this:
A B C D
# Johnson Smith Jones
9904
9354

and have the cell calculate based on column A and Row 1 matches what the
count is. ANy help? Table Example below.

A B
9904 Johnson
9354 Smith
9714 Jones
9904 Smith
8151 Jones
8154 Johnson
9904 Johnson