Dave,

Those formulas don't seem to work right if there are blank (MT) cells in the
range!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
And this array formula:
=AVERAGE(IF(A1:A100,A1:A10))
ignores 0's as well as negatives.

=AVERAGE(IF(A1:A10=0,A1:A10))
(array entered still, would ignore just the negatives)

==
Yeah, you didn't ask about this. I know. But I had to correct my error.

Dave Peterson wrote:

That's not really ignoring the negatives, but this worked ok for me:

=AVERAGE(ABS(A1:A10))
This is an array formula. Hit ctrl-shift-enter instead of enter. If
you do it
correctly, excel will wrap curly brackets {} around your formula.
(don't type
them yourself.)

If you really wanted to ignore the negatives (pretend that they didn't
exist):
=AVERAGE(IF(A1:A100,A1:A10))
This is also an array formula.

Steve wrote:

What formula would I use to average a group of numbers and ignore the
negatives? For instance, if I'm averaging +8 and -6, I want the
result to be 7, not 1. Thanks!

--

Dave Peterson

--

Dave Peterson