# SUMS

H

#### heather

OK, after the problem below I am now finding it difficult to
sum the \$ in col R by the number in Col I....example in
http://www.savefile.com/projects/808732916
I would like it to look like COL S in the end...How can I do this

Column C and D I would like to get some formula to auto enter the info.
Number from largest to smallest which i used the Larger() ...and Column D to
pull the corresponding number/letter seq from column B.

One possible way...

C2 = LARGE(\$A\$2:\$A\$1000,ROW()-1)

INDEX(\$B\$2:\$B\$1000,MATCH(C2,\$A\$2:\$A\$1000,0)))

Adjust the "1000"'s to include all of your data, then copy both down as far
as
needed.

Ok, I tried that formula but for the numbers in column A that duplicate all
it returned to me is #num!

With the data above it worked fine. Can you put a copy of your worksheet on
www.savefile.com for someone to look at?

You said columns C and D, but you really wanted columns H and I.

H2 = LARGE(\$A\$2:\$A\$1000,ROW()-1)

INDEX(\$B\$2:\$B\$1000,MATCH(H2,\$A\$2:\$A\$1000,0)))

AWESOME!!!!!!!! You are the BEST!~!!! Thank you soooooooo much!!!!!!! 18,000
gold stars for you!