PROBLEM: wasting time writing formulas to find the
Average, Count and Sum of a range.
SOLUTION: learn how in Excel you can quickly calculate the
Average, Count and Sum of a range without having to write a formula.
Excel 2010, 2013 & 2016 – Formulas in the Status Bar
When you select a range of cells in Excel and then take a look at the Excel Status Bar (bar at the bottom of the screen) you will notice Average, Count and Sum indicators. These indicators will display a result for each of the functions based on the selected area.
Note: You can add additional function indicators by right-clicking the function bar and selecting the indicator you would like displayed. If you are using Excel Online as part of your Office 365 subscription, click the arrow next to the SUM indicator to add additional functions to the Status Bar.