Google-sheets – ArrayFormula for consequential sum-up

formulasgoogle sheetsgoogle-sheets-arrayformula

Here's a sample test spreadsheet – https://docs.google.com/spreadsheets/d/

What do I have to do in the ONE cell in column D such that I won't have to copy and paste the same formula in column C throughout the entire column all the time as my data grows?

Best Answer

Allen, you can also try this:

  1. Delete everything from Column D (including the header).

  2. Place the following array formula into D1:

=ArrayFormula({"Array Formula";SUMIF(ROW(B2:B),"<="&ROW(B2:B),B2:B)+B$1})

Related Topic