hat
Fòmil sa a ap vin maladwa lè n vin pi gwo. Pou egzanp, nan sòm tèt valè 20 yo nan yon ranje, yon fòmil dwe genyen yon lis nonm antye nan 1 pou 20. Isit la se yon fòmil pi rapid ak pi pratik: =SUM (gwo (A1: D10, ROW (endirèk ("1: 20")))).
eng
This formula will become unwieldy as n gets larger. For example, to sum the top 20 values in a range, a formula must contain a list of integers from 1 to 20. Here is a quicker and more convenient array formula: =SUM(LARGE(A1:D10,ROW(INDIRECT ("1:20")))).