formula needed

  • Thread starter Thread starter Will Hudson
  • Start date Start date
W

Will Hudson

I am atempting to compare four cells, throw out the two
highest and then add the two lowest. I also need to
compare four cells, throw the one highest out and add the
remaining three.
 
Will,
You can use combinations of the LARGE, SMALL, and SUM functions:

1)
=LARGE(A1:A4,3)+LARGE(A1:A4,4)
or
=SMALL(A1:A4,1)+SMALL(A1:A4,2)


2)
=SUM(A1:A4)-LARGE(A1:A4,1)


Good Luck,
Mark Graesser
(e-mail address removed)
----- Will Hudson wrote: -----

I am atempting to compare four cells, throw out the two
highest and then add the two lowest. I also need to
compare four cells, throw the one highest out and add the
remaining three.
 
Will,

First question : =SUM(SMALL(D1:D4,{1,2})) (assuming your four numbers
are in D1:D4)
Second question : =SUM(SMALL(D1:D4,{1,2,3})) (assuming your four numbers
are in D1:D4) or :
= SUM(D1:D4) - LARGE(D1:D4,1)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top