My question is about Highline Excel 2016 Class 06

[royalnass30]

My question is about putting locks on data in a formula. for example =SUMIFS(COGS,Region,$J20,SalesRep,K$19,Product,$K$18)
Why are locks only put on the column in J20 and not the row and why are locks only put on the row in K19 and why are both locks put on K18?

This can be seen around the 13:00 minute mark in the youtube video Highline Excel 2016 Class 06: Conditional Calculations
with Excel Formulas:Comprehensive Lessons.

Thank you for reading my post and have a wonderful day!

 

[royalnass30]

I think I sort of understand it now. I guess it will just take some practice for it stick with me. We only want to lock the name Gigi because we only want to search for Gigi out of all the different sales people

 

[Michael M]

I can't view the video, but the absolute references are applied to restrict the changes to the formula.
So if the formula were to be dragged down the page J20 will always be referring to col J but can now become $J21, $J22 in the formula....
With K19 it will always refer to row 19, but could refer to other columns if dragged across the page !!
In the last instance no matter where the formula resides it can only refer to K18

 

[royalnass30]

I can't view the video, but the absolute references are applied to restrict the changes to the formula.
So if the formula were to be dragged down the page J20 will always be referring to col J but can now become $J21, $J22 in the formula....
With K19 it will always refer to row 19, but could refer to other columns if dragged across the page !!
In the last instance no matter where the formula resides it can only refer to K18



Interesting. Thanks and have a happy holiday!