summarizing matched data
 

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.

summarizing matched data
 

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.

strayshot Wrote:
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
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=568608

summarizing matched data
 

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

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

strayshot wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html