Averaging data

D

Dav

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
 
B

Bob Phillips

=AVERAGE(LARGE(1:1,ROW(INDIRECT("1:"&MIN(COUNT(1:1),30)))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

This will cater for less than 30 entries in the row.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top