Mixed Cell References in Excel(Fixed Column & fixed row references, Compute running total)

Mixed reference in excel is a type of cell reference which is different from the other two absolute and relative, in mixed cell reference we only refer to the column of the cell or the row of the cell.
Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.
The power of Excel lies in the fact that you can use these cell references in other cells when creating formulas. Understanding these different types of cell references will help you work with formulas and save time (especially when copy-pasting formulas).
00:00:00 Mixed Cell Referencing
00:03:25 Application of Fixed Column References
00:05:54 Application of Fixed Row References
00:08:15 Application of Mixed References
00:10:36 Application of Absolute & Mixed References
00:14:02 Smart Formula to Compute Running Total