Google Sheets – ArrayFormula for Conditional Consequential Sum-Up

formulasgoogle sheetsgoogle-sheets-arrayformula

I have a table which looks like this:

And formula in cell B3: =IF(A3>5, B2, B2+1) and on every next row a corresponding variation of this formula.

I would like to know how to create ArrayFormula variant of this formula:

=IF(A3>5, B2, B2+1)

spreadsheet sample here

Best Answer

=ArrayFormula({"Result";IF(A2:A="","",COUNTIFS(ROW(A2:A),"<="&ROW(A2:A),A2:A,"<=5"))})

Related Solutions

Google Sheets – Conditional Cumulative Sum Using Arrayformula in Google Sheets

If the data starts in row 2, then try:

=ArrayFormula(IF(A2:A="A",SUMIF(IF(A2:A="A",ROW(A2:A),ROWS(A:A)+1),"<="&ROW(A2:A),B2:B),))

Google-sheets – Compute the total of every row with arrayformula

The main goal is to make sum ArrayFormula. The original brilliant solution was provided here.

And your formula is:

=ArrayFormula(
IF($Q2:Q="No",
  SUMIF(IF(COLUMN(J2:P2),ROW(A2:A)),ROW(A2:A),J2:P),
IF($Q2:Q="Yes",
  SUMIF(IF(COLUMN(R2:X2),ROW(A2:A)),ROW(A2:A),R2:X),
IF($Q2:Q="",""))))

Best Answer

Related Solutions

Google Sheets – Conditional Cumulative Sum Using Arrayformula in Google Sheets

Google-sheets – Compute the total of every row with arrayformula

Related Topic