answersLogoWhite

0


Best Answer

average function

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Sums numbers then divides by the number of values?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are the sums numbers then divides by the number of values?

The average or arithmetic mean.


Sums numbers in range and divides by number of values?

Average Function


Sums number then divides by the number of values?

Average Function


What Excel function sums values and then divides by the number of values?

The AVERAGE function.


What sums of numbers then divides by the number of values?

That sounds like the mean average.


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

Average function


What function sums the numbers in a specified range and then divides the sum by the number of cells with numeric values in the range?

I assume you mean in Excel. Use the average() function.


What function sums the numbers in the specified range and divides the sum by the number of the cells?

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.


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 specified range and then divides the sum by the number of non-zero cells in the range?

The Average function.


What function sums the numbers in the specified range and thendivides the sum number cells with numeric values in the range?

The mean, except that Excel calls it "Average".


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.