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
=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