However, we can make this much easier by using a named reference.For example, if we were to rename cell A1 of Sheet2 TOTAL, we could use this within our INDIRECT reference.This is particularly ...