Use the Name Manager in Excel. Use structured references in Excel table formulas. Type the plus sign into the formula after A3.
Firstly select the whole Column C secondly enter the formula A1385 and then press the Ctrl Enter keys together.
Insert a named range into a formula in Excel. Combined with the logical functions such as AND OR and NOT the IF function has even more value because it allows testing multiple conditions in desired combinations. If we want to insert a formula in Excel then we need to get into the edit mode of the cell where we want to apply and then type equal sign. The value of the formula must start and end in quotation marks.