You can create a list of unique SS numbers quite easily by using Advanced
Filter, Debra Dalgliesh is the expert on this, have a look at her tutorials
on :-

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

Once you have that list, say in E1:E500, use the SUMIF or SUMPRODUCT formula
to get the result

=SUMIF($A$1:$A$5000,E1,$C1:$C5000)

=SUMPRODUCT(--($A$1:$A$5000=E1),--($C$1:$C$5000))

Enter either formula in say F1 and drag it down to the end of the list of SS
numbers.

Unless however you really want to use a formula for clarity or whatever, a
pivot table is the better option.

Regards,

Alan,




"LM" wrote in message
...
I think the problem is that I do not have a list of unique SS numbers to
reference?? My data table is basically a huge list of employee social
security numbers that have various salary numbers that can be attached to
them. If I "reference" cell A1 for example, don't I have to actually have
A1
separately identified first? That is my problem. What I would like to do
is
to in one step, grab the entire data table and push out the sums attached
to
each unique SS no.

I guess it's hard to explain but let me try one more time. My data is a
list of let's say 500 UNIQUE social security numbers that can show up just
once or multiple times in Column A from cell A2:A800. So, SSN 123456789
could be in A1, A2, and A3. While SSN 222334444 could be in A4 and A5.
SSN
333445555 could be just in cell A6. So forth and so on. There are
corresponding salary numbers in Column B for each 'A' cell.

With that data, how can I figure up how much in total each SSN earns? For
example, I would need to know how much SSN 123456789 earns in total as
found
in cells B1, B2, and B3. Based on the advice given, it looks like I need
a
column with each UNIQUE SSN so that I could have the formula reference
that
UNIQUE SSN to give me the sum total for that SSN. The problem with this,
is
that I don't have a list of the UNIQUE 500 SSN's readily available.

I think my best bet is to use a pivot table but I was hoping there was
formula command that I didn't know of to help me out. Thanks!