Excel Tutorial
Excel tutorials, quizzes & AI guides — all levels
RSS
  • Online Excel Exercises
  • Training
  • Excel Tests
  • Sitemap
  • Premium Quizzes
  • Shop
  • My account

Sum a whole table in one click with Quick Analysis

Excel Tutorial
Reading time: 2 minutes
Views: 517

Quick Analysis is the name given to the icon that appears after making a selection in your spreadsheet.

Excel quick analysis tool
  1. Select all cells with numbers
  2. The Quick Analysis icon is displayed at the bottom right
  3. Select the menu Totals
  4. Finally, select the Blue Sum option (the icon has the symbol Σ and a blue line for the Total)
Option Total in the Quick Analysis tool

 The sum of all columns is instantly calculated and added to the row below the selected range.

Sum of the rows with the quick analysis tool

Same trick for rows

Now, if you want to sum all the cells of the same row, the technique is the same.

  1. Select the cells you want to add
  2. Click the Quick Analysis icon
  3. Go to the Totals tab
  4. Select the Yellow Sum option (symbol Σ and a yellow column for the Total)
Quick analysis to perform a sum for the rows

The result is as follows.

Sum by row with the quick analysis tool

Frédéric LE GUEN

quick analysis, SUM

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed Posts

  • Displaying Negative Numbers in Parentheses in Excel (310,065)
  • Top 10 Excel Functions You Must Know (232,001)
  • How to make automatic calendar in Excel (212,775)
  • Dash for a zero in Excel automatically (190,812)
  • Converting a Date from YYYYMMDD to DD/MM/YYYY in Excel (171,033)
image excel exercises
Excel Exercises
image excel quizzes
Excel Quizzes

Sum a whole table in one click with Quick Analysis

Reading time: 2 minutes
Views: 517

Quick Analysis is the name given to the icon that appears after making a selection in your spreadsheet.

Excel quick analysis tool
  1. Select all cells with numbers
  2. The Quick Analysis icon is displayed at the bottom right
  3. Select the menu Totals
  4. Finally, select the Blue Sum option (the icon has the symbol Σ and a blue line for the Total)
Option Total in the Quick Analysis tool

 The sum of all columns is instantly calculated and added to the row below the selected range.

Sum of the rows with the quick analysis tool

Same trick for rows

Now, if you want to sum all the cells of the same row, the technique is the same.

  1. Select the cells you want to add
  2. Click the Quick Analysis icon
  3. Go to the Totals tab
  4. Select the Yellow Sum option (symbol Σ and a yellow column for the Total)
Quick analysis to perform a sum for the rows

The result is as follows.

Sum by row with the quick analysis tool
Tags: quick analysisSUM

Frédéric LE GUEN

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Contact us
About me 
Privacy Policy

© 2022 – 2026 – excel-tutorial.com. All Rights Reserved.
Excel Tutorial is managed by majordome du net

Contact us
About me 
Privacy Policy

© 2022 – 2026 – excel-tutorial.com. All Rights Reserved.
Excel Tutorial is managed by majordome du net