Their are lots of ways and it depends on what data is in other rows and
where the data is continuous. Average ignores blank cells. If there are
no blank cells and there are at least 30 cells something like the
following should work
=SUM(OFFSET(A10,0,COUNT(B10:BD10)-29,1,30))/30

where the data is in the range b10:bd10

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=526652