Hi!

Recently I came across this problem and I'm sure there must be a clever solution to it:

I have a range of cells (A1:A1001) that are each target cells for different elements of a user input form (little boxes to check, etc).

In case of missing values (i.e., the user forgets to check a box), I want to insert the average of all values in the range in that empty cell.

Problem: I will have a circular reference if using a function such as if(A1=0,"insert mean A1:1001",A1).

I'm sure there is a way of achieving this in Excel (must be a common problem). Can anyone help?

Thanks!
as