Have Geek Brain

Parallel sum

Can these numbers be summed up with a formula?

1
2
3
4
5
6

No, I'm not looking for = "Amount (cell ___ 1: Cell_6)".
With "Product" you multiply - I just want to add them. Like "= 1 + 2 + 3 + 4 + 5 + 6", but only with the formula. For example, "formulaName (6)".

0


source to share


4 answers


Do you mean:



Sum = n * (n + 1) / 2, where n is the last number in the sequence?

+12


source


Well ... = 6 * (6 + 1) / 2 should do it

For a more general approach, you can put 6 in, say A1, and use



= A1 * (A1 + 1) / 2

+1


source 


Function GaussForm(ByVal x As Integer) As Integer

       GaussForm = (x * (x + 1) / 2)

End Function
0


source


Not very Gaussian, but here's another way:

=SUM(ROW(A1:A6))

This is an array formula, so type with Control + Shift + Enter

0


source






More articles:


All Articles