Forum Discussion
Formulae
How do I find the the sum of the top * numbers in a given range
With 365, the formula is readable
=LET(
topN, TAKE(SORT(range,,-1), n),
SUM(topN)
)To see the workings this could be
=LET(
topN, TAKE(SORT(range,,-1),n),
VSTACK(topN, SUM(topN))
)
Just tried this, and it doesn't work. My queries are, please:
1. Why is the formula split over four columns?
2. Should there be spaces within the formula?
3. Why are there two versions?
4. Why is 'n' capitalised after 'top', but not when it is on its own, particularly as n is a value, not text?
I look forward to your replies
Thank you
1. Why is the formula split over four columns?
2. Should there be spaces within the formula?
3. Why are there two versions?
4. Why is 'n' capitalised after 'top', but not when it is on its own, particularly as n is a value, not text?
I look forward to your replies
Thank you