Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Find lowest X numbers out of a lookup

Topic Labels: Formulas
796 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Joshua_Kaplan
4 - Data Explorer
4 - Data Explorer

I have a lookup array of 6 scores, and I’m trying to see if there’s a formula where I can automatically grab and SUM the lowest 4 scores out of the 6. Does anyone know if this is possible?

Thank you!

image

0 Replies 0