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

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!