Locking values in a formula while dragging

[eschrichj]

I have a formula that I'm dragging down and taking data from each row as I drag it down. But I have a value taken from the top of the column that I want to stay the same as I drag the formula down.

=SUMIFS('Enter Data Here'!M:M,'Enter Data Here'!A:A,">="&'Monthly Reports'!L3,'Enter Data Here'!A:A,"<="&'Monthly Reports'!L4,'Enter Data Here'!J:J,"="&'Monthly Reports'!A46)

The formula works, but I want to be able to lock the portions highlighted red, so I don't have to manually fix it every time I drag the formula.

I saw that adding a $ sign will lock the values but every way I try it says there is an error in the formula, I may be adding it in the wrong place.

Thanks in advance

 

[Eric W]

Try:

=SUMIFS('Enter Data Here'!M:M,'Enter Data Here'!A:A,">="&'Monthly Reports'!$L$3,'Enter Data Here'!A:A,"<="&'Monthly Reports'!$L$4,'Enter Data Here'!J:J,"="&'Monthly Reports'!A46)

A $ before the column letter locks the column, before the row number locks the row, and before both means you're looking at a specific cell.

 

[eschrichj]

Okay that was my mistake, I was doing it only before the column letter, not both.

Thanks Eric!

 

[Eric W]

You're welcome!