Dr. GwenNURSING · EDUCATION · SCHOLARSHIP

EXCEL · DATA SKILLS

AutoSum and totals

Browse Excel lessons
  1. Excel for basic data analysis
  2. Cells and ranges
  3. Columns and readable headings
  4. Enter and edit cells
  5. Share files and embed objects
  6. Fill a series
  7. Save a practice copy
  8. Prepare data for analysis
  9. Dates and number formats
  10. Variables and score definitions
  11. Enter and check practice data
  12. Insert and delete rows
  13. AutoSum and totals
  14. Copy formulas with relative references
  15. Calculate the mean
  16. Calculate standard deviation
  17. Excel references and next steps

Select B10 and enter =SUM(B5:B9). The result is 17. C10 and D10 total their own columns and return 16 and 18.

You can also choose Home → AutoSum, then verify the highlighted range and press Enter. Never accept a suggested range without checking that it contains only the intended inputs.

A sum is a total, not a maximum. To find the largest anxiety score, use =MAX(B5:B9), which returns 5. The workbook’s row 10 is correctly labeled Total.

Reference: Microsoft Support. Menu names may vary by platform and update.

← Previous lesson · Next lesson →