How to quickly find average, count and sum in Excel 2013

Excel 2013 users can quickly find out average, count and sum of cells either horizontally or vertically using the display options available as part of excel status bar. Let us say you want to find out the average of the following series.

image

All you need to do is select those values and status bar will be display the Average, Count and Sum of those selection.

image

Missing Average or Count or Sum on Status bar.

If the functions Average, Count or Sum are displayed on the status bar then you can select them by right clicking on the status bar.

image

In Category: Excel 2013, MS Office, Office 2013

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.