How do I get to and use AutoSum in Excel?

Answer 1

select the cells that you want to total and click on the auto sum symbol. it will place the results in the next available cell below your hi-lighted cells if you are computing vertically or in the next adjacent cell if you are computing horizontally.

Answer 2

In the cell where you want the result to appear "=SUM(first cell:last cell)

Another way is to select the cells you want (typically a column) + the next cell then click the "sigma" symbol on the tool bar. The formula will be created for you.

If you change one of the cells in the equation, the total will automatically change.

Answer 3

if you are creating a table that require formula. or if you are working on a project or a worksheet that needed totals, product, percentage and among other mathematical findings. that is the funny looking e or backward 3 (the greek symbol sigma) on the tool bars. all you do is click the bottom of the column or end of the row, then click the symbol ensuring the formula stated is what you needed.

Answer 4

i imagine that the column causing you issues has textual content values that seem as if numbers yet are extremely textual content. depending upon the Excel version, you'd be in a position of rework the textual content numbers to actual numbers through fixing the formatting to a huge determination yet in some variations you may ought to re-enter the numbers as numbers.