First SUM can add up entire rows of numbers or just certain cells within a row. Even though the answer is seen in cell B2 selecting that cell displays the formula A2A3 in the formula bar above the worksheet. Excel easily performs this formula for you but there are a few tricks to SUM that provide even more functionality for adding data.
To output some TEXT.
Use these formulas for simple calculations. Type an equal sign and then type a function. To subtract use the - sign. In this tutorial we will focus on using IF.