I have this sheet:https://docs.google.com/spreadsheets/d/10YVUO2a-XftaCOX73tOiOwQfu0t80iKPJjQrRDiht1A/edit?usp=sharingIn the column E I need the same operation as ARRAYFORMULA in column C and D.In column E I need to make a simple SUM and this is what does not work.How do I resolve?UPDATED:Can I use this magic formula:=ARRAYFORMULA(IF(A1:A;A1:A*(2*B1:B);))but with SUM?I need to use this magic formula which repeat for every rows the formula i choose, but I need repeat in each rows a formula with SUM that now doesn't work. How to?
Google Spreadsheet: add automatically the same formula in each new row of a column. Also with SUM
google spreadsheets
I believe the question is: how can I provide a product of the sums of columns A and B, from the current row down to the end of the sheet, and apply this automatically down the column with an array formula?=ArrayFormula(SUMIF(ROW(A:A);>=&ROW(A:A);A:A)*SUMIF(ROW(B:B);>=&ROW(B:B);B:B))As per OP request, this will populate a header, and mask any output on rows where there is nothing in column A or B:=ArrayFormula(IF(LEN(A:A)*LEN(B:B),IF(ROW(A:A)=1,Counter,SUMIF(ROW(A:A);>=&ROW(A:A);A:A)*SUMIF(ROW(B:B);>=&ROW(B:B);B:B)),))