 # HLOOKUP or another formula?

• 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.

## Files

• 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!