Step-by-step lesson · Excel
How to use SUM, AVERAGE and COUNT in Excel
- Click an empty cell under your numbers
- Type =SUM(B2:B10) and press Return to add them up
- In the next cell, type =AVERAGE(B2:B10) and press Return
- In the next cell, type =COUNT(B2:B10) and press Return to count the numbers
More in Excel
- How to format cells as currency, percent and dates in Excel
- How to use SUMIFS and COUNTIFS in Excel
- How to use the UNIQUE function in Excel
- How to fix numbers stored as text in Excel
- How to fix dates showing as numbers in Excel