SUM

Suma un conxunto de números.

Sintaxe

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

Number 1; Number 2; … ; Number 255 are numbers, references to cells or to cell ranges of numbers.

Esta función ignora calquera texto ou cela baleira nun intervalo de datos. Se sospeita resultados erróneos desta función busque texto nos intervalos de texto. Para realzar o contido de texto nun intervalo de datos empregue a función realce de valores.

Esta función é parte da norma Formato Open Document para Aplicacións de Ofimática (OpenDocument), versión 1.2 (ISO/IEC 26300:2-2015)

Exemplos

=SUM(2;3;4) returns 9.

=SUM(A1;A3;B5) calculates the sum of the three cells.

=SUM(A1:E10) calculates the sum of all cells in the A1 to E10 cell range.

A formula such as =SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40) may be entered as an array formula by pressing the Shift+Enter keys instead of simply pressing the Enter key to finish entering the formula. The formula will then be shown in the Formula bar enclosed in braces and operates by multiplying corresponding elements of the arrays together and returning their sum.

SUM wiki page.

SUMIF, SUMIFS