Excel 2016 Use a Mixed Cell Reference in a Formula
In this video, I demonstrate how to use a mixed cell reference in Excel 2016. I demonstrate the difference between an absolute and a mixed reference. In a mixed reference, do not use two $, only use 1. You use a $ to lock either the column or row, but not both.