Seeing Calculation Results Immediately

If you are interested in seeing the calculation of numbers quickly without using formulas, you can see the results in status bar.

To see calculations results immediately:

  • Select the range of numbers that you want to calculate quickly.
  • Right-click the Status Bar to open the fast calculation menu.

Note: Remember to select a range before using this option.

Six functions are available:

  • AVERAGE
  • COUNT
  • COUNT NUMS
  • MAX
  • MIN
  • SUM

To view the calculation results for all six functions at same point of time in status bar, you need to right click on status bar & select all of them refer below snapshot.
 
img1
 
Refer below show snapshot:
 
img2
 
To see the calculation of a row, you need to select the row & results will be calculated in status bar.
 
img3
 
To quickly see the calculation of multiple rows or columns, you need to select them & results will be calculated in status bar.
 
img4
 
Example of selecting multiple columns & seeing the results in status bar refer below snapshot.
 
img5
 
 

Comments

  1. Thanks you for another great article. Where else could anyone get that kind of information in such a perfect way of writing? I have a presentation next week, and I am on the look for such information.
    autoskola-hyvnar.org |

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.