Jim


=AVERAGE(IF(D2:D18<0,D2:D18))

Enter as an array Ctrl/shift/enter


Don


"JimNColorado" wrote in message
...
I am trying to average a column of numbers. I want to only average the
cells
that contain a number greater than 0. How do I do that?