If B5 wasn't empty, B3 through B6 would be an adjacent range of cells that AutoSum could recognize. If you try to use AutoSum here, it only gets the adjacent cell, not the entire column. With larger ranges of cells, it is essential. ![]() When adding a few cells, the SUM function saves you time. This formula adds the cells from A3 through A6. The syntax, or grammar, of the SUM function is SUM, open parenthesis, arguments-like numbers or cell references separated by commas-and finally, close parenthesis. ![]() When I double-click inside a cell where I am using AutoSum, I see it is a formula with the SUM function.Ī function is a predefined formula. Then, on the HOME tab, click AutoSum, verify that the formula is what you want, and click AutoSum again.ĪutoSum adds the row or column automatically. Instead, click the cell to the right of a row or below a column. You could type out =A3+A4+A5+A6, but that is tedious. ![]() AutoSum makes it easy to add adjacent cells in rows and columns.
0 Comments
Leave a Reply. |