Auto Filling Parts of Formulas

Hello All. I am having problems auto-filling the cells in my spreadsheet correctly. I only want certain cells changed but instead it is doing all of them. For example, here is my formula: =COUNT(IF(('Scores By Standard'!G36:'Scores By Standard'!G188="x")*('Scores By Standard'!J36:'Scores By Standard'!J188="m"),1))

Now if I select the handle and scroll to the right it updates the next cell to the following:
=COUNT(IF(('Scores By Standard'!H36:'Scores By Standard'!H188="x")*('Scores By Standard'!K36:'Scores By Standard'!K188="m"),1))

The problem is that I don't want the first part of my if statement to be changed. I would like it to look like this:
=COUNT(IF(('Scores By Standard'!G36:'Scores By Standard'!G188="x")*('Scores By Standard'!K36:'Scores By Standard'!K188="m"),1))

Is there any way I can lock that down? Thanks!!!!

In order to "lock" a cell reference, you should use an absolute reference, indicated by $ . So, the references that should not change should look like $G$36.

Let me know if this helps.

Perfect!!!!!!!!!! Thanks!!!!!!!!!!!!!!!!!!