To reference a named range on another sheet, you can use the INDIRECT function with the required sheet syntax. In the example shown, the formula in D6 is: SUM ( INDIRECT ( & B6& & C6 )) Which returns the To increment a reference created as text inside the INDIRECT function, you can use the CELL function.