I'm trying to find a formula that will add the lowest 5 numbers out of 10. I have a formula that will delete one of the high numbers out of 10 but can't seem to figure out how to count the lowest 5 and ignore the highest 5. That formula I'm talking about is @sum(A1..A10)-@MAX(A1..A10). I found one on the internet for Excel but I can't find out how to change it for Lotus 123.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.