Returning a "0" value

[picktr]

Result in cell with this formula does not return a
value of 0 when referenced cell is deleted


=AVERAGE(Y3:INDEX(A3:Y3,LARGE(COLUMN(G3:Y3)*(ISNUMBER(G3:Y3)),3)))

This formula works fine, however, I need to add to it.
When I put my numbers into the cells that this formula references,
everything works fine. It gives me the avg. of the last 3 cells
with entries. ex: G3 (50) G4 (50) G5 (50)
result avg = 50

When I delete the contents of those 3 cells, leaving them empty o
numbers, the formula cell leaves the "50".

I'd like it to return to "0"

Thanks,
To

 

[Dave Peterson]

See one guess at your other post.

Result in cell with this formula does not return a
value of 0 when referenced cell is deleted

=AVERAGE(Y3:INDEX(A3:Y3,LARGE(COLUMN(G3:Y3)*(ISNUMBER(G3:Y3)),3)))

This formula works fine, however, I need to add to it.
When I put my numbers into the cells that this formula references,
everything works fine. It gives me the avg. of the last 3 cells
with entries. ex: G3 (50) G4 (50) G5 (50)
result avg = 50

When I delete the contents of those 3 cells, leaving them empty of
numbers, the formula cell leaves the "50".

I'd like it to return to "0"

Thanks,
Tom