OK, I missed that. How about this:

=AVERAGE(IF(A1:C1<0,A1:C1))

commit with CTRL SHIRT ENTER.

"Carol Mac" wrote:

Thanks Barb - doesn't do it. If A1 is 0, it still averages based on 3
instead of 2. Any other thoughts?

"Barb Reinhardt" wrote:

Try using =Average(A1:C1)



"Carol Mac" wrote:

D1=(A1+B1+C1)/3
If A1, B1 or C1 have a 0 value, can the divisor change automatically so that
it only divides by the number of columns with a value? Thanks.