summarizing matched data

S

strayshot

I get lists of ID numbers and and scores of various lenghts every day. IDs
are unique and I need to summarize scores of IDs that appear in more than one
list. Hence, Id like to have a TOTALS list that sort according to scores and
accumulate scores of IDs that appear more than once.

I will be very grateful (on a daily basis - as I do the mathing manually
now!) for any assistance.
 
S

starguy

suppose you have IDs in the range of A1:A50 and scores in B1:50
try following function

=SUMIF(A1:A50,"=ID",B1:B50)
put proper ID in formula.
 
Top