Blank cells in a formula

[jtraas]

Hello,
I am trying to write a simple formula to be copied multiple times. It is
basically the sum of several cells. When my formula finds a blank cell it
counts it as a zero. I would like it to return a blank or an error message if
any of the cells in the formula are blank. How do I do this?

 

[Bernard Liengme]

If you are summing why does it matter if blank is counted as zero
Maybe we need to see your formula
best wishes

 

[Mike H]

Hi,

One way

=IF(COUNT(A1:A10)<10,"All fields not filled",SUM(A1:A10))

Mike