July 30, 2013

Easy Way to View Sum or Average in Microsoft Excel 2010

Many times in Excel we use the SUM or AVERAGE functions.  Well did you know that if you don’t this data in a place on your spreadsheet, and just need it for a quick reference, that you don’t even have to go through the steps of using the function.  Simply highlight the cells that you would like to see the sum or average of, and look in the bottom status bar and you will see the number of cells you have selected, the sum of those cells, and the average.  You can even select cells that are not adjacent to each other by using the CTRL key will selecting your cells.

No comments:

Post a Comment