I am trying to automatically add a formula in Google sheets when row is added. The formula is an output of adding (sum) three columns.
Here is my formula:
=ARRAYFORMULA(IF(ROW(F:F)=1, "Count", IF(ISBLANK(F:F), "", SUM(F2:H2))))
The above formula populates the sum of SUM(F2:H2) in all the rows
If I use this formula:
=ARRAYFORMULA(IF(ROW(F:F)=1, "Count", IF(ISBLANK(F:F), "", SUM(F:H))))
Then the output is the total sum of column F, G, H
CodePudding user response:
You can use BYROW to have the sums of each row. Put this in Row 1 of your column
={"Count";BYROW(F2:H,LAMBDA(each,IF(COUNTA(each)=0,"",SUM(each))))}