1. The SUM function is probably the most basic function you need in Excel. You type in =SUM( and then select an array of values. This will result in the sum of the values in the array you've selected.

If your business uses an Excel file to track sales information, you can use the SUM formula to add up all order totals. The SUM formula can be applied to a certain number or cells or an indefinite ...