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...