answersLogoWhite

0

A range can be one of the arguments in a function. It can also be an array of values. It depends on the function and what it needs to work.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

What function finds the average of a range of cells?

The AVERAGE function.


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 function adds a range of cells?

SUM


What function add all numbers in a range of cells?

SUM 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)


Does the total function sum the numbers in the specified range and then divides the sum by the number of nonzero cells in the range?

To be technically accurate, no function does this. The answer you are looking for is the AVERAGE function. It divides by the amount of cells that have values in them, not by the amount of cells. In most situations, all of the selected cells have values in them, but there are cases when they don't.


What function adds all the numbers in a range of cells?

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


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

Sum Function


What is the Excel function COUNTBLANK?

It is a function that allows you to count the amount of blank cells in a range. So if you want to count how many cells were in the range from A2 to A20, the function would be as follows: =COUNTBLANK(A2:A20)


Cells can function?

only in a narrow range of temperature and pH.


What function counts the number of cells within a range that meets the given condition?

The COUNTIF function in Excel counts the number of cells that meet a specific criterion within a range. You specify the range and the criteria, and it returns the count of cells that meet that condition.


How do you calculate upper quartile in Excel?

Use the QUARTILE function, specifying the data you want in an array, and use 3 to represent the upper quartile. Say your data is in the cells from A5 to A30, you would do it as follows: =QUARTILE(A5:A30,3)