summarizing matched data

[Guest]

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.

 

[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.

 

[Debra Dalgleish]

You could create a pivot table, based on multiple consolidation ranges,
to summarize the ID numbers in all the lists. There are instructions here:

http://www.contextures.com/xlPivot08.html