try this
=AVERAGE(IF(MOD(ROW(H2:H10)-1,3)=0,H2:H10))
or
=AVERAGE(IF(MOD(ROW($H$2:$H$10),3)=1,IF(ISNUMBER($ H$2:$H$10)<"",$H$2:$H$10)))
--
Don Guillett
SalesAid Software

"LostwithoutLost" wrote in
message ...
I gave it a go, and it worked, but it did not calculate every third entry,
how do I adapt it to do that.

"LostwithoutLost" wrote:

Thanks, will give it a go.

"Don Guillett" wrote:

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