Dynamic Formula - Ignore cell Formula is in

I should have tested the formula fully. When I added the formula =average(data) I get an error because the cell that contains the formula is on the same line in the named range. How can I ignore the cell that my formula is in?

Microsoft Excel

Last Comment

Saurabh Singh Teotia

8/22/2022 - Mon

Eirman

4/22/2015

You are probably getting a circular reference error.

The simplest and most obvious solution, is to add your formula outside the named range.

You could redefine the range to exclude the cell in question.

Edward Pamias

4/22/2015

ASKER

I would love to do what you said but I can't do it. Any other suggestions? BTW, as for this suggestions "You could redefine the range to exclude the cell in question. " that wont work because that column moves every time I add a column.

Eirman

4/22/2015

I haven't been following your earlier questions.
Can you post an example or give more details

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

William Peck

ASKER CERTIFIED SOLUTION

Saurabh Singh Teotia

4/22/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options