Formula adjustment

[Mamdouh Elfors]

Hi
I want to pull the formula into a cell G75 so that it works on high, middle, low and dry1

 

[pecoflyer]

Change the absolute references to relative as required

 

[Mamdouh Elfors]

The references :
D5:D16 for high
D17:D28 for middle
D29:D40 for low
D41:D52 for dry1
How do I make it change when I pull the formula from G75 to AP94?
Thanks

 

[Mamdouh Elfors]

Please I want to solve the problem
I tried and it didn't work

 

[Mamdouh Elfors]

This formula is from the work of this forum

 

[Mamdouh Elfors]

Hi
What is the error in the formula in a cell G75?
Thanks