Duplicate lookup and sum function

[Aber05]

Hi there,

I have attached a sample workbook.

I am looking to do the following within one formula in column C:

1. Determine if column A contains one more duplicates ( Student ID = 224353 in this example)

2. If there are duplicates I would like to sum the the values in Column B for all of the identified duplicates (determine that Student ID = 224353 has a total budget allocation of 110)

3. If this number is greater than 100 I would like to indicate that within column C.

Please let me know if you have any questions.

I really appreciate any help!

Thank you

[JohnTopley]

In C2 and copy down

=IF(COUNTIF($A$2:$A$15,$A2)>1,IF(SUMIFS($B$2:$B$15,$A$2:$A$15,$A2)>100,"Over 100",""),"")

Student ID = 224353 =100 not 110

[LeoTaxi]

Or

C2 and copy down

=IF(SUMIF(A:A,A2,B:B)>100,SUMIF(A:A,A2,B:B),"")

[Aber05]

Thank you so much!!