Wednesday, March 26, 2014

yogi_Compute Row By Sum of Counts In Multiple Columns And Running Total of Counts In All Columns

                                         Google Spreadsheet   Post  #1576
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Mar-26-2014
post by Tj Mesler (!msg/docs/aGkiePJhMqM/34uhWbfK66gJ)
How to get a formula copied to new row?
Ok, I'm a spreadsheet newbie and have done some research but just don't understand how to do what I want.

I have a formula in column H that sums up the values in the previous 5 columns. I want it to expand down the sheet for each row added.

So i tried =ArrayFormula(SUM(C2:H2)) but it doesn't get expanded into any new rows added.

Bonus question : I would also like to keep a running total for each column, but then adding rows gets harder. Is there a way to add rows 1 above the last row?