Sum of every alternate n and n+1 rows

[Dr. Shivaji Saha]

Hi,

I have a data array A2:A20 and calculated the sum of every n rows by using the following formula.

=SUM(OFFSET($A$1,(ROW()-1)*2,0,2,1))

But, How can I get the sum of n+1 rows present in the same array by using a single formula? Is this possible?

Best,
Shivaji

[JohnTopley]

With A1 blank

in C2

=SUM(OFFSET($A$1,INT((ROWS($1:1)-1)/2)*5+IF(ISODD(ROWS($1:1)),0,3),0,IF(ISODD(ROWS($1:1)),3,2),1))

pattern is 3,2 etc with A1 blank.

[Dr. Shivaji Saha]

Hi,

Thanks for your prompt response.

I have attached another file where you can see a different situation. There is no particular pattern like the 3rows-2rows pattern.
Does any VBA script work for this situation?

[JohnTopley]

Yet again, wasting respondents time [providing a solution] and then changing the parameters.

And no it will not work with VBA (except based on cell colour!) or formula because there is no way of determining the (random) pattern .

[kvsrinivasamurthy]

There will be some parameter to decide the number of rows each time to sum. Unless you come up with complete details it is not possible to provide solution.

[JohnTopley]

Based on colouring alternating blocks as per your post:

Please Login or Register  to view this content.