Sum if Calculation

[Ted Dennis]

I am looking to use a formula possibly a sumif to add all values in column b where column a is the same and return that total in this instance at the bottom of the list of names in column A (where the 8 currently is). ANy help would be greatly appreciated

Thanks

[NBVC]

Try:

=IF(A2=A3,"",SUMIF(A$2:A2,A2,B$2:B2))

copied down

[Special-K]

in C2
=SUMIF(A$2:A$21,A2,B$2:B$21)

and copy down