Hi
If I understand you correctly for the range you want to remain static you need to enter a "$" before both the Col and Row numbers. When that formula is then replicated elsewhere that section will not change.
Hope this helps.
Good luck.
Tony