look at the rank function,there is a section there on how to rank ties.Hope
you can use it!
--
paul

remove nospam for email addy!



"damorrison" wrote:

I have a list something like this

A C
2 22
3 25
4 36
11 38
9 45
4 36
5 22
2 45
5 25

I would like to Sum the values in column A according to the values in
column C

Add the 1st largest of column C
45=11
2nd largest
38=11
3rd largest
36=8
ect
when I use the =large() formula and there is more than one number, well
it doesn't work, there are 2 -45's so the 3rd largest number is 38 when
it should be the 2nd largest

Thanks