Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jun 10, 2013
user Alvinator (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/g6gHzBZaBfk)
Sum of a counted amount of cells
I have a finance management spreadsheet/sheets and I need to know how to achieve a "X day total" column.
I mean that for example, in Column A, I have the sums of each day's earnings, then in column B I would like to have a formula that would sum up the adjacent A cell along with the preceding X number of cells. X would be defined at the top of the B column (B2 for example, as titles would be in the 1 row).