I have a problem I need some help with. I have data entered into rows on spreadsheets, and I want to know how I can find the 3 lowest numbers of the four and add them together in a cell to the right of the row. I've attached an example of what the sheet will look like. Thank you for your help.
HLOOKUP or another formula?



Re: HLOOKUP or another formula?
Put =LARGE(B2:H2,4)+LARGE(B2:H2,3)+LARGE(B2:H2,2) into cell J2. That will add the second, third and fourth largest of the four scores together.

Re: HLOOKUP or another formula?
Try:
=sum(small(b2:h2,{1,2,3}))
EDIT: Too slow,

Re: HLOOKUP or another formula?
I learn so much here. I love this place!

Re: HLOOKUP or another formula?
Either one works :), but I think yours was adding the 3 highest and mine the 3 lowest. Concept is the same.
with 4 values to look at:
=SUM(LARGE(B2:H2,{1,2,3})
is the same as:
=SUM(SMALL(B2:H2,{2,3,4})
of course the second relies on only having 4 values, so would be wrong if more were added later.


Re: HLOOKUP or another formula?
Mine was adding the 3 lowest too, just not as elegantly.

Re: HLOOKUP or another formula?
Oh...yea. Had to take another look....2, 3, and 4...gotcha
If it works, it works...doesn't have to look pretty
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!