A2 is within the range A:IT, and would therefore produce a circular
reference. It looks like you might be able to use COLUMN(A1:AT1) instead.
If that doesn't solve the problem, try copying the formula from the formula
bar and paste that into your post, instead of retyping the formula. As
posted, the formula gives a #NAME? instead of a circular reference, because
of the IT:Index...

Jerry

"brian thompson3001 via OfficeKB.com" 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