Conditional Averages

[Kris Andersen]

I'm trying to calculate the average of ONLY the positive numbers from a
column of both positive and negative numbers. I'm sure there's an easy way
to do it, but everything I've tried hasn't worked. Any suggestions greatly
appreciated!

Kris

[Duke Carey]

This is an array formula, meaning you commit it with Shift-Ctrl-Enter

=AVERAGE(IF(A1:A10>0,A1:A10))


"Kris Andersen" wrote:

> I'm trying to calculate the average of ONLY the positive numbers from a
> column of both positive and negative numbers. I'm sure there's an easy way
> to do it, but everything I've tried hasn't worked. Any suggestions greatly
> appreciated!
>
> Kris