Finding the average of more than 30 arguments

[jschwartz]

How can you find the average of more than 30 numbers?

 

[Domenic]

How can you find the average of more than 30 numbers?

If those numbers are contained in cells A1 to A30...

=AVERAGE(A1:A30)

If you want to exclude 0 (zero) values...

=AVERAGE(IF(A1:A30<>0,A1:A30))

....entered using CONTROL+SHIFT+ENTER.

Hope this helps!

 

[Myrna Larson]

The limit of 30 means 30 arguments. Each argument can refer to a range of
cells, like A1:A100. If that still doesn't help, you can assign a name to a
range that consists of a multiple selection.

 

[jschwartz]

However, what if the numbers are in separate cells and not
in a range?

 

[jschwartz]

However, what if the values are in noncontiguous cells?

 

[Domenic]

However, what if the numbers are in separate cells and not
in a range?

Can you give us more information? Where are these cells located?

 

[Bernard Liengme]

As the lady said: you can assign a name to a range that consists of a
multiple selection. A multiple section is a non-contiguous range.

Try this:
In A1, D1, G1 enter number, 2,3, and 5, respectively
Click on A1, holding CTRL click on D1 and then on G1: You have selected a
non-contiguous rand (multiple selection)
In the Name box type myN and hit the Enter key
In B3 enter =SUM(myN) and you will get 10

Extend this example to your problem

Best wishes

 

[Jerry W. Lewis]

As an alternative to named ranges, consider that

=AVERAGE(A2,A4,A6,A8,A10,A12,A14,A16,A18,A20,A22,A24,A26,A28,A30,
A32,A34,A36,A38,A40,A42,A44,A46,A48,A50,A52,A54,A56,A58,A60,
A62,A64,A66,A68,A70,A72,A74,A76,A78,A80,A82,A84,A86,A88,A90,
A92,A94,A96,A98,A100)

refers to 50 discontinuous cells via 50 arguments, and so is not permitted.

=AVERAGE((A2,A4,A6,A8,A10,A12,A14,A16,A18,A20,A22,A24,A26,A28,A30,
A32,A34,A36,A38,A40,A42,A44,A46,A48,A50,A52,A54,A56,A58,A60,
A62,A64,A66,A68,A70,A72,A74,A76,A78,A80,A82,A84,A86,A88,A90,
A92,A94,A96,A98,A100))

refers to 100 discontinuous cells via 1 argument, and so works without
error.

Jerry