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