Home > OS >  How to reference to a previous row within a column with Arrayformula in Google Sheets
How to reference to a previous row within a column with Arrayformula in Google Sheets

Time:10-06

i'm working on a schedule tool, but can't figure something out. I'd like to use the arrayformula function in Google Sheets. It should sum up two values from the previous row.

At the moment I'm using this, but i'd like to convert it into an arrayformula. I've tried several things, but end up with the 'Circular dependency detected' message.

=iferror(IF(REGEXMATCH(C5;"DAY");E5;index(G:G;ROW(G5)-1;1) H6);index(G:G;ROW(G5)-1;1) H6)

Here's the doc:

enter image description here

  • Related