Conditional Averages

K

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
 
D

Duke Carey

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

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