Averaging data
 

I need to average only the last 30 entrys in a row of data. Is thier a
way?


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

Averaging data
 

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

Averaging data
 

=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)

"Capt Bill" wrote
in message ...

I need to average only the last 30 entrys in a row of data. Is thier a
way?


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