Brian,

Sum the range and divide by CountIf(cell < 0)

SteveM


Brian wrote:
I am looking to average a range of numbers, but I want to exclude any cell that has a zero from the Average. In this particular case, the zero's are filler only and have no real meaning but they are distorting my figure.

I can't seem to find the magic formula to make it function.

Brian