Quick Analysis in Excel

I'm often asked if Microsoft Excel is able to place a 'sum' total to the side of a column, instead of at the bottom of a column. The Quick Analysis tool can help you do that.

(1) Select the cells you want to sum, and (2) left-click the Quick Analysis icon (bottom right-corner of selection) or keyboard shortcut is Ctrl + Q.

From (3) the Quick Analysis dialog box, select Totals, next select the 'Sum' totals feature that will place it to the side not at the bottom.

Please note: the Quick Analysis tool is only available in Excel 2013 & later versions only.

Write a comment

Comments: 2
  • #1

    Matt (Thursday, 02 September 2021 02:36)

    Awesome stuff! I actually like the Sparklines feature the most: Here's how to use it: https://spreadsheetdaddy.com/basics/quick-analysis-tool/

  • #2

    Raphael (Thursday, 02 September 2021 10:49)

    BE AWARE, that the above mentioned website plagiarizes other people's hard earned work and the owner of the domain name exists incognito.