One way
In B1, array-enter by pressing CTRL+SHIFT+ENTER,
instead of just pressing ENTER:
=AVERAGE(IF(ISNUMBER(A1:A10),A1:A10))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"tylermdsm" wrote:
i'm trying to average 5 cells. One has an #n/a value. This causes the
average to say #n/a. Is there a way to correct this?