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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Blank cells in a formula 2
Give blank in cell 2
Excel Concatenate with line breaks but ignore blank cells 3
Need Formula - If blank cells 3
Excel Sumproduct 0
Sum number range ignoring numbers formatted as text 0
Using COUNTA and excluding formulas that gives zero or blank cells 3

Top