Question: how to create a formula using quick analysis tool in excel?
Answer: Select the range of cells you want to total. ... 
Click the Quick Analysis button. ... 
Click Totals.
To preview the totals result, point to the button (select an icon with blue row) with the type of total calculation you want.