Link to home
Start Free TrialLog in
Avatar of Edward Pamias
Edward PamiasFlag for United States of America

asked on

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?
Avatar of Eirman
Flag of Ireland image

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.
Avatar of Edward Pamias


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.
I haven't been following your earlier questions.
Can you post an example or give more details
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If I could give you a 1000 points I would. This was perfect. Thanks for all the help in the last couple of days.

Thanks for appreciation and always happy to help .. :-)