answersLogoWhite

0

SUM(1st range, [optional 2nd range], [optional 3rd range], [& so on])

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

What is the Excel function that adds all the numbers in a selected range of cells is the?

Sum Function


What function adds a range of cells?

SUM


What is the Function that adds the values of cells in a range and divides the result by the number of cells?

The AVERAGE function.


What adds all the numbers in a rang of cells?

SUM function


What is the Excel formula for adding how many of a category?

It sounds like you are asking about the SUMIF function. SUMIF adds all numbers in a range of cells, based on a given criteria.=SUMIF(range,criteria,sum_range)range = range of cells that you want to apply the criteria against.criteria = determines which cells to add.sum_range = range of cells to sum.


How does an autosum formula differ from an average formula?

An autosum formula calculates the total sum of a range of cells, while an average formula calculates the average value of a range of cells. The autosum function adds up the numbers in the selected range and can be applied to any numerical data, whereas the average function calculates the arithmetic mean of the numbers in the selected range.


What function adds the cells specified by a given condition or criteria?

The SUMIF function in Excel adds cells based on a single condition or criteria. If you have multiple conditions, you can use the SUMIFS function instead.


What is a function that automatically adds the values in the cells directly above or to the left of the active cell?

The function you are referring to is likely the SUM function in spreadsheet software like Excel or Google Sheets. This function allows you to add the values in a range of cells either vertically (above the active cell) or horizontally (to the left of the active cell) by specifying the range within the function.


What is a common function in Excel?

The most basic function in Excel is SUM() Other functions are AVERAGE, MIN, MAX


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

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


Which adds all of the numbers in a range of cellsprovides a convinient means to calculate a total?

=SUM(A1:A15) If this SUM formula is put into cell A16, then the numbers in the cells above (A1 to A15) will be shown in cell A16 as a total.


Which function adds all the numbers in a range without having to write a formula?

If you mean Excel, you always need a formula; there is no way around that. As a shortcut to adding numbers individually, you can use the SUM() function. Within the parentheses, you can write a range, for example: =SUM(A1:A4) This is a function but it is still also a formula. You may have confused the two things. All functions in use are in formulas and you can have formulas that have no functions.