Spreadsheet Formula Different for each row

Good Morning everyone,

Its been a long time, all my apps are running great but running into sync time problems.

Im trying to get a Spreadsheet formula to work and get rid of some formulas in the app, Here is my dillema.

Each Row of the spreadsheet needs a differant formula…

This is the formula for the first row under the headers.
=sumifs($J:$J, $D:$D, D2, $E:$E, E2, $R:$R, “<>True”) - sumifs($K:$K, $D:$D, D2, $E:$E, E2, $R:$R, “<>True”)

Second row
=sumifs($J:$J, $D:$D, D3, $E:$E, E3, $R:$R, “<>True”) - sumifs($K:$K, $D:$D, D3, $E:$E, E3, $R:$R, “<>True”)

Third Row
=sumifs($J:$J, $D:$D, D4, $E:$E, E4, $R:$R, “<>True”) - sumifs($K:$K, $D:$D, D4, $E:$E, E4, $R:$R, “<>True”)

How Would I get these to change in the spreadsheet formula when a new row is added

Many Thanks and what an amazing amount of changes that have happened while I’ve been away with wonderfully running apps with no problems.

1 Like