Excel and averages

[jschwartz]

How do I find the average of more than 30 numbers from
noncontiguous cells?

 

[NH]

Will this help
=average(A1,b2,c3:c15.....)

 

[RagDyer]

You could perhaps create a range and then use that in the formula.

=AVERAGE(myrange)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

message How do I find the average of more than 30 numbers from
noncontiguous cells?

 

[Paul Corrado]

While holding down the CRTL key, use the mouse to select each cell you wish
to include in the average calculation. Then in the Name Box in the upper
left hand corner of your screen, type in a name for the range. (I use DATA
as my name in the example below

Then use that Name in the formula instead of listing the individual cells.

=AVERAGE(DATA)

Note that the Named Range is not referenced with ""'s

 

[Ken Wright]

So in what way are they not contiguous? Give us an example, eg is it that you
have every other cell in say Row 2 with a number and you want to average those?
Lots of ways to skin a cat, but we need as much info as you can give to be more
precise.