answersLogoWhite

0


Best Answer

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)

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is A formula that adds up a series of numbers in a column or a row?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is a predefined formula that adds all the numbers in a selected range?

=SUM(range) or=SUBTOTAL(9,range)


What is the purpose of using Data Tables?

In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.


What adds to 5 and multiples to -20?

-15


What adds to get -7 and multiplies to get -2?

-9


What times what is -145 and adds up to -5?

-150


What does the autosum function do?

it adds up all the entries in a row or column.


What times what is -145 and also adds up to -5?

-150


What adds to -11 and multiplies to -20?

The numbers rounded to 5 decimal places are: 1.58872 and -12.58872 A more accurate answer can be found by using the quadratic equation formula


What multipys to 18 and adds up to -17?

The numbers are: -1.1345 and -15.8654 to 4 decimal places A more accurate result can be found by using the quadratic equation formula


When does euler's formula not work?

his formula does not work because if you get a cone it adds up to 0


What feature adds organization to your documents?

page numbers.


How do you average a math question?

To get the simple average of a series of numbers, you add the numbers up and divide by however many numbers there were. For example, the average of 2, 3 and 4 is the sum of the numbers (which adds up to 9) divided by 3 (because there are three numbers). So the average is 9/3 = 3.