Hi,

I think the solutions you have do work. By the way your example shows both
the raw data and the results in the same columns? Is this a key to why it
doesn't work?

If you data is in D1:F8 for example, then in A1:B5 enter

1 11
2 12
3 5
4 13
5 5

Where the formula in B1 is

=SUMIF(D$1:D$8,A1,F$1:F$8)

And you copy it down.



--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"LM" wrote:

Those formulas don't work?? Here's a more elaborate example of what I'm
looking for:

Columns A (Employee SS), B (Project No), and C (Salary) as follows
A..................B...............C
1..................X..............$5
1..................Y..............$6
2..................X..............$5
2..................Z..............$7
3..................Y..............$5
4..................Y..............$6
4..................Z..............$7
5..................X..............$5
Total............................$46

Desired Result:
A.................B
1.................$11
2.................$12
3.................$5
4.................$13
5.................$5
Total...........$46

Thanks!

"~L" wrote:

The sum of salary for all projects by SSN:

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

"LM" wrote:

Ok, imagine column A is a list of social security numbers. Column B is a
list of project names. Column C is a listing of salaries for those social
security numbers. I need to have excel calculate for me each social security
number's total salary.

SSN............Project #......Salary
123456789.....32...........$12,000
123456789.....45...........$15,000
333445555.....31...........$11,000
444556666.....45...........$15,000

So, in this example, you can see that the person with SS# 123456789 worked
on 2 different projects and earned a sum of $27,000. Is there a formula that
I can put into the spreadsheet to do this all the way down? I have over
2,000 records so I can't possibly do this by hand. Thanks.