Edward Pamias

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?

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.

I haven't been following your earlier questions.

Can you post an example or give more details

Can you post an example or give more details

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

If I could give you a 1000 points I would. This was perfect. Thanks for all the help in the last couple of days.

epamias,

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

Saurabh...

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

Saurabh...

The simplest and most obvious solution, is to add your formula

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