formulas with blank cells

J

jtraas

Hello,
I am trying to add 10 cells and divide them by 10. (SUM(A1:J1))/10 however
if any of the cells are blank I do not want it to calculate the formula I
would like it to return a blank or some text such as NOT ANSWERED. HOW do I
do this, I have tried everything.
 
M

Mike H

The way it was explained in your previous post

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

Mike
 
Top