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
 
 



One thought on “Seeing Calculation Results Immediately

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>