If you need add/exclude more cells, you can hold the Shift Key > Arrow key of your choice until your selection matches what you want, and press Enter when you're done. All you need to do is press Enter to confirm it. The AutoSum Wizard has automatically detected cells B2:B5 as the range to be summed. The AutoSum dialog also lets you select other common functions like: Note it’s not going to work on non-contiguous ranges, but we'll go over that in the next section. It can also work horizontally if you select a cell to the left or right of the range to be summed. The AutoSum Wizard will automatically sense the range to be summed and build the formula for you. Select an empty cell directly above or below the range that you want to sum, and on the Home or Formula tabs on the Ribbon, press AutoSum > Sum. The easiest way to add a SUM formula to your worksheet is to use the AutoSum Wizard.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |