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.
All you need to do is select those values and status bar will be display the Average, Count and Sum of those selection.
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.