answersLogoWhite

0

A colon would be between the two cell references that make a range like in these:

=SUM(B2:B10)

=AVERAGE(V20:X23)

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

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 will show the smallest value in the selected range of cells?

The function that shows the smallest value in a selected range of cells in spreadsheet applications like Microsoft Excel or Google Sheets is the MIN function. For example, if you want to find the smallest value in the range A1 to A10, you would use the formula =MIN(A1:A10). This function will return the lowest number from the specified range.


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.


What function finds the average of a range of cells?

The AVERAGE function.


How do you enter the formula to count the number of cells with numbers in a range of cells?

You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)You use the COUNT function. Say your range was the cells for A2 to A20. In another cell you would enter the following function:=COUNT(A2:A20)


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.


An easy way to verify that a formula references the cells that you want it to reference is to use Excel's?

Range finder. Double clicking on the formula activates the range finder and you can see what cells are in the formula. This can help you see if the correct cells are in the formula.


What function adds a range of cells?

SUM


What function add all numbers in a range of cells?

SUM function


What kind of formula is function in Excel?

A function is a pre-written or built-in formula in Excel. There are many of them, all designed to do very specific tasks. The SUM function is one of the most common, making it easy to add a range of cells. See the related question below.


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.


What highlights cells that provide data to a formula?

Range Finder