March 26

0 comments

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

By Sharyn Baines

March 26, 2014

AVERAGE, COUNT, Shortcut, SUM

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.

 

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

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.

If you found this post helpful please ‘Like’ us!

[DISPLAY_ULTIMATE_PLUS]

If you enjoyed this post you may also enjoy:

Sharyn Baines

About the author

Sharyn is an expert trainer. She became the first certified Microsoft® MOUS Authorised Instructor in New Zealand. She is endorsed by Microsoft® as a qualified Microsoft® Office Specialist and has more than 20 years of experience in the training industry, developing and delivering technology training workshops. Her approach to taking the “techie-speak” out of technology training has placed her as a preferred supplier to many of New Zealand’s leading organisations.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

JOIN FREE! 'Excel at Work Insiders Group' for free tutorials, mini-courses, videos and blogs!

>