Solved: Need help with selective sum in Excel... Thanks Kranky!

[slydecix]

Ok, let's say i have the following:

id#__Score
1____23
2____43
4____56
2____33
2____17
1____40
2____59
8____13


I need a function that totals all the scores for those with id# 2 only, no matter how long the table is and what i sort it by (whether its id#, score, or some other variable)

I can't find my install cd, so can't use the Conditional Sum add-in...

i've tried a few things but it always gives me an error... any ideas?

 

[kranky]

Let's say your ID numbers are in column A, and the scores are in column B.

Use the formula =SUMIF(A:A, "=2",B:B )

 

[slydecix]

Originally posted by: kranky
Let's say your ID numbers are in column A, and the scores are in column B.

Use the formula =SUMIF(A:A, "=2",B:B )

It worked! Thanks!