0
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?
Wiki User
∙ 9y ago
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.
Wiki User
∙ 8y ago
Wiki User
∙ 6y agoThe Average function.
= AVERAGE(specified range)
= AVERAGE(specified range)
Wiki User
∙ 9y agoThere is no function called Total. The function that does what you say is the Average function.
Wiki User
∙ 11y agoThe mean, except that Excel calls it "Average".
Wiki User
∙ 10y agoI assume you mean in Excel. Use the average() function.
Wiki User
∙ 6y agoOne function which performs his function, in Excel, is "averageifs"
Wiki User
∙ 6y agoOne function which performs this function, in Excel, is "averageifs"
Wiki User
∙ 6y agoThe Average function.
Wiki User
∙ 11y ago=AVERAGE(range) will.
Add your answer:
Earn +20 pts
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.
Sums numbers then divides by the number of values?
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 in range and divides by number of values?
Average Function
What sums numbers in range and divides by number of value?
Average function
What function compare the numbers in the specified range and then return with the largest number?
Maximum.
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 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.
