Documentation/Calc Functions/SUMKV

From The Document Foundation Wiki
Jump to navigation Jump to search
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:
English • ‎Nederlands • ‎dansk • ‎español • ‎italiano

Template:Documentation/Calc Functions/Func Page Links/da

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 #VALUE! 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{SUMSQ}(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:

Template:Calc-Formula/da Template:Calc-Description/da Template:Calc-Returns/da
=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