How to add (x) amount of rows, then add the next (x) amount of rows

[Moo1987]

Hi,

I have a date and time column in Column A and a value in colmun B.

I need to take the value 150 rows down e.g row 151 and minus the value in B2. I then need to repeat this for every 150 rows, so the next calculations would be (B301-B152), then (B452 - B302).

Is there a formula I can just drag down to give me the answer?

 

[Special-K99]

"I need to take the value 150 rows down...and repeat every 150 rows"
"(B301-B152), then (B452 - B302)"

The number of rows between B301 and B452 is 151 not 150.
Is that a typo?

You need to define clearly what your data is and check it before posting.

B301-B152 In what cell would this reuslt be stored?
B451-B302 In what cell would this reuslt be stored?

 

[Tetra201]

Try this:

=INDEX(B:B,ROWS($B$1:$B1)*150+1)-INDEX(B:B,ROWS($B$1:$B1)*150-148)

 

[Moo1987]

Thanks for the reply Special-K99, sorry first post i've done, i'll take that onboard.

 

[Moo1987]

Thanks tetra201!!! Works perfectly!!!

 

[Tetra201]

You are welcome.