KGRÖSSTE/LARGE in Array

  • Resolved lenschith

    (@lenschith)


    5 years, 8 months ago

    Hello,

    I would like to create a ranking list in which the best 12 results are evaluated.
    In Excel I use the following formula.

    {=SUMME(KGRÖSSTE(F2:Z2;ZEILE(1:12)))}
    or {=SUMME(LARGE(F2:Z2;ZEILE(1:12)))}

    I tried ={SUM(LARGE(F2:Z2;ROW(1:12)))}, but it do not work.”!ERROR! unexpected comma”

    How can I map this with Tablepress?

    Thank you.
    Greetings Lenschi

    • This topic was modified 5 years, 8 months ago by lenschith.
    • This topic was modified 5 years, 8 months ago by lenschith.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)

The topic ‘KGRÖSSTE/LARGE in Array’ is closed to new replies.

Tags