answersLogoWhite

0

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.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

Function sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range?

AVERAGE(range)


What function sums the numbers in the specified range and then divides the sum by the number zero?

No function will add numbers up and divide the total by zero, as it is a mathematical impossibility to divide by zero. If your question meant to say that you want to divide by the amount of numbers that were summed to make the total, then the function is the AVERAGE function.


What is the product of two or nonzero whole numbers?

The product of two nonzero whole numbers will be a nonzero whole number.


Sums numbers then divides by the number of values?

average function


Sums numbers in range and divides by number of values?

Average Function


What sums numbers in range and divides by number of value?

Average function


What is the leats common factor of any two nonzero whole numbers why or why not?

The LCf of any two nonzero whole numbers is one because every nonzero whole number can be divided by it.


What function compare the numbers in the specified range and then return with the largest number?

Maximum.


What is a factor of 2 nonzero numbers?

1


What type of numbers are always significant?

All nonzero numbers are significant.


Is the quotient of two nonzero numbers never a rational number?

The quotient of two nonzero integers is the definition of a rational number. There are nonzero numbers other than integers (imaginary, rational non-integers) that the quotient of would not be a rational number. If the two nonzero numbers are rational themselves, then the quotient will be rational. (For example, 4 divided by 2 is 2: all of those numbers are rational).


What do you call two or more nonzero numbers?

A set of non-zero numbers.