Tweaking a SUMIF formula

[JOGIER]

The following formula finds the lowest five values in row 6 from column H to W. However if there are less than five values in the row the formula returns 0.
I need to tweak it to return the smallest 5 values weather there is one or a full row of 16. Also if there are any of the same values I still want only the five lowest.

Please Login or Register  to view this content.

Thanks,

Jim O

[daddylonglegs]

Try like this

=SUMPRODUCT(SMALL(H6:W6,ROW(INDIRECT("1:"&MIN(5,COUNT(H6:W6))))))

[JOGIER]

daddylonglegs,

That works perfect.

Thank You.

Jim O