Need a quick total or count without having to write a formula?  Excel’s AutoCalculate will show you a total, a count, an average, or other calculations by simply selecting the cells you are calculating.  Look on the lower right hand portion of the status bar to see the calculated result.

Sum is the default calculation.  To change the type of calculation, right-click on the status bar and choose from the pop-up menu which calculation you want to perform.