Documentation/Calc Functions/SUMKV

    From The Document Foundation Wiki
    This page is a translated version of the page Documentation/Calc Functions/SUMSQ and the translation is 7% complete.
    Outdated translations are marked like this.
    Other languages:


    Funktionsnavn:

    SUMKV

    Kategori:

    Matematisk

    Resume:

    Beregner summen af kvadrattallene af en række tal.

    Syntaks:

    SUMKV(Number 1 [; Number 2 [; … [; Number 255]]])

    Returnerer:

    Returnerer et ikke-negativt, reelt tal, som er summen af de indtastede tals kvadrattal.

    Argumenter:

    Tal 1, tal 2, … , tal 255 er reelle tal, referencer til celler eller til celleområder med de tal, hvis sum skal beregnes.

    Note that although SUMKV can accept up to 255 arguments, each argument could specify a range of cells. This means that the number of real numbers processed could be many more than 255.

    The following conditions (including errors) may be encountered:

    • If any argument is a string in quotation marks, then SUMKV reports a #VÆRDI! error.
    • Text in cells and empty cells are ignored.
    • If there are no supplied numbers, then SUMKV returns the value 0.
    • If only one value is supplied, then SUMKV returns that value squared.

    Yderligere oplysninger:

    • If N1, N2, …, Nk represent a set of k real numbers passed to the function, the formula for SUMKV is:

    [math]\displaystyle{ \text{\lt span lang="en" dir="ltr" class="mw-content-ltr"\gt SUMSQ\lt /span\gt }(N_{1}; N_{2}; ...; N_{k})=N_{1}^2+N_{2}^2+...+N_{k}^2 }[/math]

    • SUMKV ignores any text in cells or empty cells. If you suspect wrong results, look for text within the supplied data range(s). To highlight text content within a data range, use Calc's View ▸ Value Highlighting feature.

    Eksempler:

    Formula Description Returns
    =SUMKV(2; 3; 4) Here the function calculates 22+32+42 and returns the result. 29
    =SUMKV(A1:A3; B1:B2) where cells A1, A2, A3, B1, and B2 contain the numbers 2.2, 3, -5, 1.3, and -7 respectively. Here the function calculates 2.22+32+(-5)2+1.32+(-7)2. 89,53
    =SUMKV({2; 4; 6; 8}) Here the function calculates 22+42+62+82 and returns the result. 120

    Beslægtede LibreOffice-funktioner:

    POTENS

    SUM

    ODF standard:

    Tilsvarende Excel-funktioner:

    SUMKV