try this average if formula. It is an ARRAY formula so must be entered using
ctrl+shift+enter

=AVERAGE(IF(K1:K40,K1:K4))

--
Don Guillett
SalesAid Software

"elarscott" wrote in message
...
I'm using Excel and trying to do averaging using averaging in the formula
there are zero's with in the infomration that I would like to not be
included
in the averaging how can I remove them from the formula?