Formula Query

[Andy T]

This is bugging me so if anyone can help I'd be very grateful. If I have a
range of numbers, say A11 and I have a very simple formula to sum those
numbers is it possible to force the result to represent say "#N/A" if one of
the numbers in my range A11 is missing. In other words, unless I have a
figures in each of the cells A11 I don't want the calculation to happen.

Many thanks as always

 

[Arvi Laanemets]

Hi

=IF(COUNT(A11)<>4,"#N/A",SUM(A11))

 

[Andy T]

Thank you Arvi, this works perfectly.

Hi

=IF(COUNT(A11)<>4,"#N/A",SUM(A11))