Make sure that you array enter it, that is Ctrl-Shift-Enter, not just Enter.

--
__________________________________
HTH

Bob

"Kcope8302" wrote in message
...
I have a worksheet with afew thousands entries. I want to average each
column
but I am having a problem since some of the cells have errors. I want to
ignore those errors since they are part of the data and still average the
data in the column. The formula I used is:
=AVERAGE(IF(NOT(ISERROR(D2:D16)),D2:D16)). But i only get 0.