Excel – Find the Average, Count and Sum of a range without having to write a formula

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

If you take a look at the Excel 2013 status Bar you will notice Average, Count and Sum indicators.  When you select a range of cells the function indicators will display a result for 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 found this post helpful please ‘Like’ us!

Facebook
Facebook
Twitter
Google+
Google+
http://excelatwork.co.nz/2014/03/26/find-the-average-count-and-sum-of-a-range-without-having-to-write-a-formula