Even if you've never created a formula, you can still find the sum, average, or count of a cell range. That's because Excel calculates these values automatically whenever you select a cell range.
It displays them in the lower-right corner of the window. This allows you to find quick information about your spreadsheet at a glance.
The video below will show you where to locate these specific values.
Alternatively, you can use the AutoSum button to add up values, which looks like this: Ʃ. This button is located in the Home tab and in the Formulas tab on the Ribbon; select the values you want to sum, and hit Enter.
Using Excel's automatic calculations is a fast and easy way to view basic information. It makes it so that you can still analyze your data without having to create complex formulas.
Stay tuned for Lesson 10–about why you should avoid merging cells.