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 ...

Have you ever thought of the humble SUM function as a secret weapon for advanced analytics? Most Excel users see it as ... making sure accurate totals. For example, if you need to count rows ...