Try this:

Select an empty cell on your raw data sheet.
Copy that empty cell: EditCopy
Now, select the range of "numbers" in column A.
Then: EditPaste SpecialAddOK
This should change the format of column A to GENERAL and convert the "text
numbers" back to numeric numbers.

Biff

"Greg C" wrote in message
...
OK that works, but it appears the numbers that are listed in column A are
not
numbers and reformatting is not helping. When I re-type the number in
column
A it populates the value on the summary. This sheet has 4000 rows, so
it's
not practical to retype the values. Any advice?

Thanks for your help!

"T. Valko" wrote:

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