Q: Sums numbers then divides by the number of values?

Write your answer...

Submit

Still have questions?

Continue Learning about Other Math

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.

you can make at least 25 sums

"Sum" requires at least two numbers. So there cannot be athree digit number that sums to anything.

Well, 1 is equal to 1. 9 is equal to 9. So any number from 0 to 9. I do not think this is what is meant by the question. If you mean any number with more than one digit. There is no such number. Because 11 sums to 2. 19 sums to 10. 21 sums to 3. 29 sums to 11. 111 sums 3. 119 sums to 11. The sums do not grow as fast the increase of digits.

Add all the sums, then divide by the number of sums. (ie. the average.)

Related questions

The average or arithmetic mean.

Average Function

Average Function

The AVERAGE function.

That sounds like the mean average.

Average function

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

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.

AVERAGE(range)

The Average function.

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

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.