Scrolling down a formula without all fields being changed

[bksparkz]

Hello everyone,
I am having trouble scrolling a formula down my excel list. When I scroll the formula down, the cells change (which is supposed to happen) but I need some of the cells in the formula to stay the same. The following is the formula......

=SUMPRODUCT(--('Enrolled Patient Log HTN'!Q22:Q4105>A150),--('Enrolled Patient Log HTN'!Q22:Q4105<=A154),--('Enrolled Patient Log HTN'!I22:I4105="HTN Only"),--('Enrolled Patient Log HTN'!R22:R4105="Graduated"))

In this formula I need the Q I & R cells to stay the same (22:4105) when I drag down the formula. I do need the A cell to change with the dragging down.

How can I do this? I have to keep going in cell by cell and changing the Q I & R numbers, which takes a very long time.

Please help.

Thank You

 

[mikerickson]

Use Absolute Referencing
'Enrolled Patient Log HTN'!$Q$22:$Q$4105

 

[bksparkz]

Wow. Such an easy fix, and all that time it took me to go in one by one.
Thank You very much.