Documentation/Calc Functions/SUMSQ/da

Funktionsnavn:
SUMKV

Kategori:
Matematisk

Resume:
Beregner summen af kvadrattallene af en række tal.

Syntaks:
SUMKV(tal 1 [; tal 2 [; … [; tal 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 SUMSQ 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 SUMSQ reports a #VALUE! error.
 * Text in cells and empty cells are ignored.
 * If there are no supplied numbers, then SUMSQ returns the value 0.
 * If only one value is supplied, then SUMSQ returns that value squared.

Yderligere oplysninger:
SUMKV(x1,x2,x3,...,xn) = x12 + x22 + x32 + .... + xn2
 * Celler, der indeholder ikke-numeriske værdier ignoreres.
 * Formlen for funktionen SUMKV er:

$$\text{SUMSQ}(N_{1}; N_{2}; ...; N_{k})=N_{1}^2+N_{2}^2+...+N_{k}^2$$


 * SUMSQ 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 feature.

Beslægtede LibreOffice-funktioner:
POWER

SUM

ODF standard:
Section 6.16.65, Part 2

Tilsvarende Excel-funktion:
SUMKV