Google Sheets array formula calculate sum column A:A

1
votes

I need a simple array formula that calculates the sum from $A$2 to the column in A:A in array formula the picture explains everything enter image description here

2
google-sheetssumgoogle-sheets-formulaarray-formulascumulative-sum

2 Answers

1
votes

try:

=ARRAYFORMULA({"Total"; IF(A2:A="",, SUMIF(ROW(A2:A), "<="&ROW(A2:A), A2:A))})

3

0
votes

i found it ^_^

`=arrayformula(SI(A1:A="Number";"Total";SOMME.SI(LIGNE(A1:A);"<="&LIGNE(A1:A);A1:A)))`