Sum Every n-rows which Contain Data

[KnightVision]

Dear readers, the problem I am facing is how to sum every 2 consecutive rows which contain data, and place the sum value in the adjacent column across from the 2nd row. Then, the formula will move down to the next two rows which contain data, and perform the sum again.

There are values in the DATA column, but it is not continuous. There are sometimes rows with blank cells, and thus I cannot just use a formula to sum every two rows. I need a formula to search for the first row with data, then find the next row which contains data, and then sum those two rows. There is no pattern to the DATA column; values appear randomly. The table should look like this, for the column titled SUM:

A	B	C
Row	DATA	SUM
1	2.5
2	3	5.5
3
4
5
6	4
7
8
9	12	16
10
11

So, in the example above: I need the sum of every two rows of DATA, and this sum will move down the column of SUM.

So, the formula in column C will need to sum DATA for Rows 1 & 2, producing (2.5) + (3) = (5.5), placed across from the second value in DATA.

Also, it will need to sum DATA for Rows 6 & 9, producing (4) + (12) = (16), placed across from the second value in DATA.

Any help will be greatly appreciated and thank you for considering this problem. If it helps, all the data is in an Excel Table (DATA and SUM are column headers). So will it be easier using absolute/table references? Thanks.

[José Augusto]

Hi

Try this in C2 and copy down (note: C1 must not contain a number or it's 0)

Please Login or Register  to view this content.

[KnightVision]

Worked out just perfectly as I needed! Thank you so much.

[José Augusto]

You are welcome. I'm happy to have helped.

Please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.