Conditional Averages
 

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

Conditional Averages
 

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

=AVERAGE(IF(A1:A100,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