a value formula
Chat with our AI personalities
Type... =SUM( ...into the box you want the answer to appear in. Click and drag from the first number yo want to add up, to the last number you want to add in that column/row and then close the brackets and hit enter so you might end up with something that looks like this... =SUM(B9:B23)
Add up all the numbers, divide the total by how many numbers there were. that is the formula for mean.
-8
Line up the decimal points in a vertical column. Then add the numbers while ignoring the decimal point. Finally, put a decimal point in the answer in the same column as for the summands.
If there are any numbers which are integers and so do not have a decimal point, then append one at the extreme right. Then arrange all the numbers in a column, with their decimal points aligned. Ad up the numbers ignoring the decimal points entirely. In the answer insert a decimal point under the column of decimal points.