Scrolling down a formula without all fields being changed

bksparkz

New Member
Joined
Mar 20, 2014
Messages
36
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
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

bksparkz

New Member
Joined
Mar 20, 2014
Messages
36
Wow. Such an easy fix, and all that time it took me to go in one by one.
Thank You very much.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,789
Messages
5,524,885
Members
409,609
Latest member
Channingz

This Week's Hot Topics

Top