Sorry Jerry, think I gave a bum steer on my first posting. I did get this
formula off the net. and it was for column average of last numbers, I
attempted to convert into row. My result is required in the same row as the
last numbered cell. Have tried sugestion but no joy.

Regards

Brian

brian thompson3001 wrote:
using formula in A2 =average(IT:Index(A1:IT1,sumproduct(large(column(A :IT)*
(A1:IT1<""),A4))))
A4 is variable cell for calculation. However, I require result to be in row
1. Keep getting curcular ref. Require result in B3

Can anyone assist?

brian(at )thompson3001.fsnet.co.uk
Regards

Brian

--
Message posted via http://www.officekb.com