AVERAGE with conditions
=AVERAGE(IF(A1:A1000, A1:A100,""))
This is an array formula. Use CTRL + SHIFT + ENTER to enter it in A101
If done properly, Excel will place { } around the formula.
Gord Dibben MS Excel MVP
On Wed, 7 Feb 2007 11:54:01 -0800, mr_concrete
wrote:
I have a column of numbers (zero to 99) that i want the average of the
numbers that are more than zero. Any idea on how to do that the best way???
|