###### Asked in Microsoft Excel

Microsoft Excel

# The auto Sum function is used to create a formula that includes a range of cells?

## Answer

###### Wiki User

###### February 23, 2013 4:42PM

Yes, that is its main function. It can also add individual cells or values or the results of other functions. Here are various examples:

=SUM(A2:A20)

=SUM(A2,A6,122,A30,B16,20,25)

=SUM(MAX(A2:A20),MAX(B2:B20))

## Related Questions

###### Asked in Microsoft Excel

### How can i get the cell values of a group of cells say 5 their values being 1000 2000 30004000 and 5000 respectively the answr is 15000 bt instead i want to get the right a but omit 1 cell value?

Use the SUM function to add all of the cells, or just use the +
with the cells you want if you want to omit one. You can put the
formula wherever you want in relation to the cells with those
numbers in them.
Use the SUM function to add all of the cells, or just use the +
with the cells you want if you want to omit one. You can put the
formula wherever you want in relation to the cells with those
numbers in them.
Use the SUM function to add all of the cells, or just use the +
with the cells you want if you want to omit one. You can put the
formula wherever you want in relation to the cells with those
numbers in them.
Use the SUM function to add all of the cells, or just use the +
with the cells you want if you want to omit one. You can put the
formula wherever you want in relation to the cells with those
numbers in them.
Use the SUM function to add all of the cells, or just use the +
with the cells you want if you want to omit one. You can put the
formula wherever you want in relation to the cells with those
numbers in them.
Use the SUM function to add all of the cells, or just use the +
with the cells you want if you want to omit one. You can put the
formula wherever you want in relation to the cells with those
numbers in them.
Use the SUM function to add all of the cells, or just use the +
with the cells you want if you want to omit one. You can put the
formula wherever you want in relation to the cells with those
numbers in them.
Use the SUM function to add all of the cells, or just use the +
with the cells you want if you want to omit one. You can put the
formula wherever you want in relation to the cells with those
numbers in them.
Use the SUM function to add all of the cells, or just use the +
with the cells you want if you want to omit one. You can put the
formula wherever you want in relation to the cells with those
numbers in them.
Use the SUM function to add all of the cells, or just use the +
with the cells you want if you want to omit one. You can put the
formula wherever you want in relation to the cells with those
numbers in them.
Use the SUM function to add all of the cells, or just use the +
with the cells you want if you want to omit one. You can put the
formula wherever you want in relation to the cells with those
numbers in them.

###### Asked in Microsoft Excel, Visual Basic Programming

### How can you use sum method in formula bar?

You can type in the SUM function directly in the formula bar. So
if you wanted to add the cells from A2 to A20, you would type
in:
=SUM(A2:A20)
You can type in the SUM function directly in the formula bar. So if
you wanted to add the cells from A2 to A20, you would type in:
=SUM(A2:A20)
You can type in the SUM function directly in the formula bar. So if
you wanted to add the cells from A2 to A20, you would type in:
=SUM(A2:A20)
You can type in the SUM function directly in the formula bar. So if
you wanted to add the cells from A2 to A20, you would type in:
=SUM(A2:A20)
You can type in the SUM function directly in the formula bar. So if
you wanted to add the cells from A2 to A20, you would type in:
=SUM(A2:A20)
You can type in the SUM function directly in the formula bar. So if
you wanted to add the cells from A2 to A20, you would type in:
=SUM(A2:A20)
You can type in the SUM function directly in the formula bar. So if
you wanted to add the cells from A2 to A20, you would type in:
=SUM(A2:A20)
You can type in the SUM function directly in the formula bar. So if
you wanted to add the cells from A2 to A20, you would type in:
=SUM(A2:A20)
You can type in the SUM function directly in the formula bar. So if
you wanted to add the cells from A2 to A20, you would type in:
=SUM(A2:A20)
You can type in the SUM function directly in the formula bar. So if
you wanted to add the cells from A2 to A20, you would type in:
=SUM(A2:A20)
You can type in the SUM function directly in the formula bar. So if
you wanted to add the cells from A2 to A20, you would type in:
=SUM(A2:A20)

###### Asked in Microsoft Excel

### What is the function of function bar in Microsoft Excel?

You are probably referring to the formula bar. It displays the
current content of cells and allows you to add in formulas, labels
or values into a cell. You can also start the Insert Function
dialog box by clicking on the fx at the beginning of the formula
bar. You can choose a function from there and it can be included in
a formula.

###### Asked in Microsoft Excel

### Does a named range change when it is copied as part of a formula?

If a formula copied includes the actual name of a range, then
when you copy it, the name will stay and so will the reference to
the original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.

###### Asked in Microsoft Excel

### Why are the dollar signs necessary in the VLOOKUP?

They are not always necessary. If your formula is not going to
be copied then you don't need them. If you are copying a formula
using a VLOOKUP function, then the reference to the cells for your
table will change and then your formula won't work, because it
won't be looking at the correct cells for your table. If you use
the dollar signs then the reference to the table will not change
when the formula is copied and the function will work correctly.
The dollars change them to absolute references, so they stay the
same when copied. Without the dollars they are relative references
and will change when the formula is copied.
They are not always necessary. If your formula is not going to be
copied then you don't need them. If you are copying a formula using
a VLOOKUP function, then the reference to the cells for your table
will change and then your formula won't work, because it won't be
looking at the correct cells for your table. If you use the dollar
signs then the reference to the table will not change when the
formula is copied and the function will work correctly. The dollars
change them to absolute references, so they stay the same when
copied. Without the dollars they are relative references and will
change when the formula is copied.
They are not always necessary. If your formula is not going to be
copied then you don't need them. If you are copying a formula using
a VLOOKUP function, then the reference to the cells for your table
will change and then your formula won't work, because it won't be
looking at the correct cells for your table. If you use the dollar
signs then the reference to the table will not change when the
formula is copied and the function will work correctly. The dollars
change them to absolute references, so they stay the same when
copied. Without the dollars they are relative references and will
change when the formula is copied.
They are not always necessary. If your formula is not going to be
copied then you don't need them. If you are copying a formula using
a VLOOKUP function, then the reference to the cells for your table
will change and then your formula won't work, because it won't be
looking at the correct cells for your table. If you use the dollar
signs then the reference to the table will not change when the
formula is copied and the function will work correctly. The dollars
change them to absolute references, so they stay the same when
copied. Without the dollars they are relative references and will
change when the formula is copied.
They are not always necessary. If your formula is not going to be
copied then you don't need them. If you are copying a formula using
a VLOOKUP function, then the reference to the cells for your table
will change and then your formula won't work, because it won't be
looking at the correct cells for your table. If you use the dollar
signs then the reference to the table will not change when the
formula is copied and the function will work correctly. The dollars
change them to absolute references, so they stay the same when
copied. Without the dollars they are relative references and will
change when the formula is copied.
They are not always necessary. If your formula is not going to be
copied then you don't need them. If you are copying a formula using
a VLOOKUP function, then the reference to the cells for your table
will change and then your formula won't work, because it won't be
looking at the correct cells for your table. If you use the dollar
signs then the reference to the table will not change when the
formula is copied and the function will work correctly. The dollars
change them to absolute references, so they stay the same when
copied. Without the dollars they are relative references and will
change when the formula is copied.
They are not always necessary. If your formula is not going to be
copied then you don't need them. If you are copying a formula using
a VLOOKUP function, then the reference to the cells for your table
will change and then your formula won't work, because it won't be
looking at the correct cells for your table. If you use the dollar
signs then the reference to the table will not change when the
formula is copied and the function will work correctly. The dollars
change them to absolute references, so they stay the same when
copied. Without the dollars they are relative references and will
change when the formula is copied.
They are not always necessary. If your formula is not going to be
copied then you don't need them. If you are copying a formula using
a VLOOKUP function, then the reference to the cells for your table
will change and then your formula won't work, because it won't be
looking at the correct cells for your table. If you use the dollar
signs then the reference to the table will not change when the
formula is copied and the function will work correctly. The dollars
change them to absolute references, so they stay the same when
copied. Without the dollars they are relative references and will
change when the formula is copied.
They are not always necessary. If your formula is not going to be
copied then you don't need them. If you are copying a formula using
a VLOOKUP function, then the reference to the cells for your table
will change and then your formula won't work, because it won't be
looking at the correct cells for your table. If you use the dollar
signs then the reference to the table will not change when the
formula is copied and the function will work correctly. The dollars
change them to absolute references, so they stay the same when
copied. Without the dollars they are relative references and will
change when the formula is copied.
They are not always necessary. If your formula is not going to be
copied then you don't need them. If you are copying a formula using
a VLOOKUP function, then the reference to the cells for your table
will change and then your formula won't work, because it won't be
looking at the correct cells for your table. If you use the dollar
signs then the reference to the table will not change when the
formula is copied and the function will work correctly. The dollars
change them to absolute references, so they stay the same when
copied. Without the dollars they are relative references and will
change when the formula is copied.
They are not always necessary. If your formula is not going to be
copied then you don't need them. If you are copying a formula using
a VLOOKUP function, then the reference to the cells for your table
will change and then your formula won't work, because it won't be
looking at the correct cells for your table. If you use the dollar
signs then the reference to the table will not change when the
formula is copied and the function will work correctly. The dollars
change them to absolute references, so they stay the same when
copied. Without the dollars they are relative references and will
change when the formula is copied.

###### Asked in Microsoft Excel

### What is a function according to Microsoft Excel?

A function is a pre-defined formula that is built into the
spreadsheet program and can be used as a formula or as part of a
formula. There are many such functions, the most commonly used one
being the SUM function, which allows you to quickly add up values
in a range of cells. To add all the values from all the cells from
cell A1 to A15 would be done with the SUM function in a formula
like this:
=SUM(A1:A15)
See related links for more information.

###### Asked in Microsoft Excel

### How do you create a formula to find the average cost in Microsoft Excel?

First you need to work out your costs. When you have the costs,
you need to know what cells on the spreadsheet those costs are in.
Then you use the Average function to get an average of those costs.
If all your costs are in the cells from B2 to B15 are, your formula
would be:
=Average(B2:B15)
That formula can't go in any of those cells, so it could go in
B16 perhaps. If the costs are in cells that are not beside each
other, you may have to reference them differently. Say your costs
are in cells B3, B7, B9, C10, C14 and D15, then your formula would
be:
=Average(B3,B7,B9,C10,C14,D15)
So once you know where your cells are, you use the Average
function and reference the cells that your costs are in. It is a
good idea to lay your spreadsheet out in a structured way, as that
will make your formulas easier to create. You can see that the
first one is simpler than the second one, even though the first one
averages far more cells.

###### Asked in Genetics

### What is the function of T-cells?

###### Asked in Computers, Microsoft Excel

### How terms formula and function related?

A formula is an instruction in a spreadsheet to carry out some
activity, normally a calculation. A formula must begin with the
equals sign. Formulas can be simple or complex and they are built
by the user. A function is a pre-defined formula that is built into
the spreadsheet program and can be used as a formula or as part of
a formula.
This is a simple formula, multiplying values in two cells by
each other:
=B3*D10
The SUM function is a commonly used function. It can be used in
a formula like these examples:
=SUM(A2:A14)
=SUM(A2:A14) * 12