I know the title is a mouthful, let me try to explain:
I have a sheet that looks as follows (this is a condensed version):
1 2 3 4 1 2 3 4 1 2 3 4 5 6 1 2 3 4 5 6 7 8
What I would like to do is create a column that SUMs the first half of each row. Assuming the rows in the table above are labeled A, B, C, D (I couldn't figure out how to do that in HTML), I would want the cell in the first row of this new column to be = SUM(B1:B2), the next row to be =SUM(C1:C3) and the next one to be =SUM(D1:D4). I would like to be able to drag this formula down, as the actual table has about 100 rows. How could this best be done? I hope I articulated my question well.
Thank you
Bookmarks