Excel 2019/365: Formulas: Mixed cell references
A mixed cell reference is where half of the reference is absolute (has a $) and the other half is relative (no $), like $A1 or A$1. This is useful when you have a table where every number in the table depends on a number from the leftmost column and it also depends on a number from the topmost row.