"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