Excel Function Video: Adding numeric amounts and SUM 

Adding Numeric Amounts in Excel

Overview

• This video covers how to add numeric amounts using Excel, specifically in a worksheet that lists costs for a bucket manufacturer.

• Two methods are described for adding amounts: the basic addition using the plus sign and the SUM function.

Method 1: Adding Specific Cells

• Basic Addition: Use the plus sign to add specific cell values.

  • Step-by-Step:

    • Select cell B15.

    • Type the equal sign (=) to indicate a formula will be entered.

    • Select cell B3, type the plus sign (+), and then select cell B12.

    • Press the Enter key.

  • Formula: The formula in cell B15 should display as =B3+B12 in the formula bar.

• Other Cells: Repeat the process for other cells:

  • In cell C15, the formula should be =C7+C10.

  • In cell D15, add the four amounts from column D.

  • In cell E15, add the four amounts from column E.

Method 2: Using the SUM Function

• The SUM function is a more efficient way to add amounts across rows or columns.

  • Step-by-Step:

    • Select cell F3.

    • Go to the Home menu ribbon and click on the SUM function icon in the editing tab on the far right.

    • Excel typically anticipates the cells you want to add (shows as =SUM(B3:E3) in F3).

    • Press the Enter key to accept the formula.

• In case of uncertainty: If Excel is unsure which cells to include, the formula may default to =SUM(E4) when you subsequently select the SUM icon.

  • Correct Selection: You should then select cells B4 to E4 and press Enter.

• Repeat Process: Continue using the SUM function:

  • For cells F5 through F14 to add the remaining rows.

  • In cell F15, use the SUM function to total amounts from cells B15 through E15, resulting in total costs of $205,900.

Conclusion

• Both methods (individual cell addition and the SUM function) will yield the same total for added amounts.

• It is important to understand which method best suits your needs when working with numerical data in Excel.