Hello i am trying to make google sheet array function to auto fill formula in case of Column C have any value Like a,b,c, Etc i have try this but its not work

=arrayformula(IF(C2:C="","",F1-D2:D E2:E))

CodePudding user response：

First solution

in F1

=arrayformula(E1:E-D1:D)

in G1

=arrayformula(SUMIF(ROW(D1:D),"<="&ROW(D1:D),F1:F))

other solution, in F1

=arrayformula(mmult(1*(transpose(row(D1:D))<=row(D1:D)),E1:E-D1:D))

CodePudding user response：

Try This !

=ArrayFormula(IF(C2:C="",,INDIRECT("F1:F"&ROWS(F:F)-1)-D2:D E2:E))