Average only if all cells filled

C

chuck72352

Is there an easy way to modify the formula below to only give a result
ONLY if all five cells (C4 through C8) have values entered?

=IF(ISERROR(ROUND(AVERAGE(C4:C8),1)),"",ROUND(AVERAGE(C4:C8),1))

Thank you,
Chuck
 
P

Per Jessen

Hi

This should do it:

=IF(COUNTBLANK(C4:C8)=0,IF(ISERROR(ROUND(AVERAGE(C4:C8),1)),"",ROUND(AVERAGE(C4:C8),1)),"")

Regards,
Per
 
L

Luke M

=IF(COUNT(C4:C8)=5,ROUND(AVERAGE(C4:C8),1),"")

Since count only detects numbers, ensures that 5 numbers are present before
averaging.
 
C

chuck72352

For some reason I get "False" as my average whether or not I have
numbers in the five cells. I'm using as you suggested:

=IF(COUNTBLANK(C4:C8)=0,IF(ISERROR(ROUND(AVERAGE(C
4:C8),1)),"",ROUND(AVERAGE(C4:C8),1)),"")
 

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

Top