Hi
Suppose I have a formula Sum(a1:a100).

How do I display an error instead of the sum if any of the cells is blank or non numeric (zero accepted).

Thanks