Use this array formula(must be entered using ctrl+shift+enter) to average <
" "
=AVERAGE(IF(H2:H10<" ",H2:H10))

--
Don Guillett
SalesAid Software

"LostwithoutLost" wrote in
message ...
Hi there, thanks for all your help in advance. I am looking for a formula
that will average every 3rd entry on a row of data. I would like to set
it
up so that it ignores empty cells. chris