In my embarrassment I was too egar to post and posted rubbish. AVERAGE
cannot average anything like that.

=SUM(MyList,MyList2)/20

should do it.

If you want me I'll be over in the corner <g

Regards

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
"Peo Sjoblom" wrote in message
...
Yes, I don't know where I got the last 10 values. <g
Must have been the subject.


I was even worse than you. If I had followed the link that you gave the
OP
I would have seen that you can have a dynamic named range of the last 10
rows and another of the last three rows, both of them covering both
columns.
All that is required then is the formula:

=AVERAGE(SUM(MyList)+SUM(MyList2))

My apologies for sounding off like an idiot.

Regards

Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk