• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part: VI Appendixes > Using QuickSum

Using QuickSum

The most frequently used function is the SUM function, which adds together the values in the cell range. For example, typing @sum(C3..C7) is the same as typing +C3+C4+C5+C6+C7. As mentioned earlier, you can click and drag across the cells that you want to add together so that you don’t even have to type the cell addresses. Notice the @ symbol at the beginning of the SUM function. This symbol precedes all functions. If you are typing in a function, you can insert the @ symbol with a Shift+2.

Wouldn’t you know it—there is an even quicker way to add together the values in a series of cells. You can click and drag through the cells that you want to add together, and if you include a blank cell at the end of the selection, QuickSum places the total in that cell.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint