Pattern in formulas dragging

[KoenS]

Hi everyone,

I have this problem: I have a formula which contains searching for particular numbers in cells. I need to know how to repeat this formula for every following 95 cells.

This is my first formula:
=(SUMIF(H2:H97;">19000")/4)-(19000*COUNTIF(H2:H97;">19000")/4)


By dragging I want it to be the following:
=(SUMIF(H98:H193;">19000")/4)-(19000*COUNTIF(H98:H193;">19000")/4)


This means, these ranges have to increase by 95. I have to do this till cell H35041, so doing it by hand isn't really an option.


Can anyone help me? This is my first time on this forum, so I don't know if I've asked the question right.


Cya

[Special-K]

Each row should increase by 96 not 95, H2:H97 is 96 rows.

=(SUMIF(INDIRECT("H"&(ROWS($1:1)-1)*96+2&":H"&(ROWS($1:1)-1)*96+97);">19000")/4)-(19000*COUNTIF(INDIRECT("H"&(ROWS($1:1)-1)*96+2&":H"&(ROWS($1:1)-1)*96+97);">19000")/4)

[KoenS]

Thank you very much! It worked perfectly!