All I did was highlight the selected rows I wanted and I got a sum AND average. Normally I'd do a summation (total amount) in a different column. This just reduced the amount of work I've had to do for my monthly reports!
# re: Excel 2007, best hidden feature ever that was in excel 2003.
# re: Excel 2007, best hidden feature ever you are a moron, that was actually in excel 200o, who knows maybe even before!!!
# re: Excel 2007, best hidden feature ever I thought it was a cool feature and asking multiple people I know, no one knew this was built in so I figured I'd share. Not everyone uses excel every day. By the way, I wouldn't suggest calling someone a moron then mistype 2000.
# re: Excel 2007, best hidden feature ever This feature has existed for some time, but only in Excel 2007 and up is it actually visible all the time. Prior to that (Excel 2000-2003), you have to right click the status bar to view these, and then you could only view one at a time. So there is a difference in Excel 2007.
