$29.99
$17.99
$15.99
$11.99
$9.99
$4.95
$37.98
$9.96
$3.77
$11.82
<equals what?>
Put them in a table column.
Also, keep the sum in a table cell.
- Create a table with suitable size.
- Enter your numbers.
- Start typing an equals sign
=into the sum cell and you will enter a sort of “spreadsheet mode”. - Type
sumand then drag across the cells you want to sum to generate the range reference. - Press enter to calculate.
This doesn’t work. When you highlight all the numbers in the column and hit enter, they disappear.
I followed the instructions of selecting the column of numbers and pressing the “sum” icon and all the numbers disappeared. I could not recover them so had to close the document without saving it and reopen it. I then tried typing the formula as =SUM(C2:C22) and received the error message “expression is faulty.”
You do need to enter the Edit formula mode
- Click in cell C23 (where you want the total)
- Click Table > Edit formula (F2). [You can enter = in the cell and it will enter edit formula mode unless there is something in there already]
- You can click the fx icon and select Sum, or you can type in the formula bar
=sumand then drag over the cells you want to sum. You should see the formula bar fill with the sum,=sum<C2:C22> - Press Enter or click the green tick
Help is here Formula