Saturday, July 12, 2014

yogi_Compute In A Row Column By Column Sum Of All The Entries In Rows Below

                                  Google Spreadsheet   Post  #1695
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-11-2014
post by AL:): (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/FLsyS2R8Pls)
HEADER FORMULA TO ARRAY SUM COLUMNS AND TOTAL WITHIN A ROW
Hello Spreadsheet Gurus,

I would like a formula to:
1) be placed in the header title
2) sum data in a column
3) auto-populate the column sums into 1 row.

Here's my attempt:
=ARRAYFORMULA(IF(COLUMN(B5:5)=COLUMN(),"TOTAL",IFERROR(IF(LEN($B$5:5),SUM(C6:C),""),FALSE)))

The formula generates the title and has data on the corresponding columns. Problem is that it only sums column C. How do I modify the formula so that it sums columns D,E,F, etc?

Sheet: SumAcross!
Cell: B4 (actually B4:4 depending if there's data in row 5)

Thanks for reading this post!

AL
------------------------------------------------------------------------------------------------------------------------------------------------