=AVERAGE(IF(ISERR(A1:A7),"",IF(A1:A7=0,"",A1:A7))) as an array formula
(Control Shift Enter)
--
David Biddulph

"Meenie" wrote in message
...
I have excel 2003:
I'm averaging a column of figures and I want to ignore any cells that have
a
zero or that have a #REF!
(0 only means that report hasn't been turned in yet, and #ref! means the
sheets that this worksheet will link to haven't been created yet - it's a
YTD
sheet.)
Thanks, Meenie