Excel's INDIRECT function turns a text string into a ... This is why the result is 5. In this example, typing =SUM(INDIRECT(A2)) into cell B2 first turns A2 into a cell reference, and then sums ...

Formulas are powerful tools for performing calculations and analyzing data in Excel ... function. Find more details, examples, and best practices for these functions at Microsoft’s SUM function ...