Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sum here using criteria there?
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL - Meet 2 criteria, then find next case of third criteria | Excel Worksheet Functions | |||
=DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
criteria 1(a,b,c), criteria 2 (T,F) - Results (3 answers) achievab | Excel Discussion (Misc queries) | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |