It is possible to perform quick calculations in Excel without having to write any formulas. This technique is brilliant and provides the formula result you need quickly and easily.
You can count, sum, average and find the maximum or minimum number in a range simply by selecting the numbers you want to calculate.
Quickly Calculate Values in Excel
- Right click on the Status Bar at the bottom of the screen
- Select the type of calculations you want to perform.
In Excel 2007 and above you can display all five formula results if you wanted to. In Excel 2003 only one can be visible at any given time, but you just need to come to the Status Bar to switch formula when needed
- Select the cells that contain the numbers you want to calculate
- The formula results are displayed on the Status Bar