Auto Calculator feature in Excel

Excel 2010 has a quick Auto Calculator feature which can be found in bottom right corner of Excel window.

Usage:- Suppose you need to find the sum of values in a row / column / range, just select that and look into the bottom right corner of Excel window, you will find the Sum along with Average and Count results for the data you selected.  Also when you right click on the results, you will find a pop-up with the calculations like Max, Min, Numerical Count etc. (see the image attached)

Comments

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.