How do I make my range reference stay the same throughout the sheet?

Jennifer Whittemore

For instance, I have this formula: =SUMIF([Week Number]1:[Week Number]68, 4, Quantity1:Quantity68). I need to use it multiple times but changing the criteria value (in this reference, this "4", which I will change manually based on the number I am looking for). But each time I either copy/paste or drag, it changes the ranges from 1:68, to 2:69, and so on. In excel I could use a $ to make it stay. How to do that here? Please?

Jennifer Whittemore

Never mind, I figured it out; I had my $ in the wrong spot.

Andrée Starå

@Jennifer Whittemore

Excellent!

Glad you got it working!

 ✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!