CODEWITHSUNDEEP
google-sheetssumgoogle-sheets-formulaarray-formulascumulative-sum
Hàmmà Bèn Àissà
Hàmmà Bèn Àissà

Reputation: 23

Google Sheets array formula calculate sum column A:A

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

Upvotes: 1

Views: 119

Answers (2)

player0
player0

Reputation: 1

try:

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

3

Upvotes: 1

H&#224;mm&#224; B&#232;n &#192;iss&#224;
H&#224;mm&#224; B&#232;n &#192;iss&#224;

Reputation: 23

i found it ^_^

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

Upvotes: 0

Related Questions