Wednesday, February 27, 2008

Automatic Sum in Excel


Sometimes you would like to know the sum of a range of cells in an Excel spreadsheet, but
you don't need to input a formula to get it. Rather than getting out the old-fashioned
calculator, all you need to do is to highlight the cells containing the data to be totaled, and
the sum is already calculated for you. Take a look in the status bar across the bottom of
the Excel program. (If you don't have a status bar across the bottom then go to the View
menu and check the Status Bar option).
There it is! I use this feature all the time if I need the sum for another worksheet or report, or just a quick look at the total. For example, in a billing spreadsheet in which each invoice is on its own line,
I can highlight all the cells containing the invoice amounts to get a quick total of the invoicing we're doing this month. Handy!




3 comments:

  1. I used Ms. Excel everyday, thanks for your tips, it make a job easy.

    ReplyDelete
  2. This is extremely helpful info!!! Especially since you guys are offering it for free!! Very good listing. Everything is true. Thanx.
    --------------------------------------------
    Dissertation Help | Custom Dissertation

    ReplyDelete
  3. Very impressive work. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own blog. heartly thanks for this review.

    ReplyDelete

Please leave your comments or your promotion links, but don't add HTML links into the comment body, because I consider it as a spam, and will be delete..

Thank you for your visit..