Question

what is the funtion of sigma in spreadsheet?

Please answer it fast becoz day after tomorrow I have my computer exam....☺☺☺☺​

Answer 1

Answer:

Sigma is a Greek letter that looks like the Latin letter M on its side! That is, ∑

In mathematics and statistics Sigma, ∑, means sum of, to add together.

The Sigma function in Excel, therefore, is SUM(values)

Imagine you have the numbers 1, 2, 3, 4, 5 in cells A1 to A5 respectively, then the answer to the Sigma formula is

∑(1,2,3,4,5)

=SUM(A1:A5)

=15