SUM(1st range, [optional 2nd range], [optional 3rd range], [& so on])
Sum Function
SUM
The AVERAGE function.
SUM function
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.
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.
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.
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.
The most basic function in Excel is SUM() Other functions are AVERAGE, MIN, MAX
=SUM(range) or=SUBTOTAL(9,range)
=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.
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.