Copying off the net is not the same as copying from Excel. You either need
to describe what you expect the cell to do, or point to the web address where
you got the formula, because it is not clear what you are up to, and the
posted formula does not work and does not give the error that you report.

Jerry

"brian thompson3001 via OfficeKB.com" wrote:

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