Average only if all cells filled
 

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(AVER AGE(C4:C8),1))

Thank you,
Chuck


--
chuck72352
------------------------------------------------------------------------
chuck72352's Profile: http://www.thecodecage.com/forumz/member.php?userid=482
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113816

Average only if all cells filled
 

Hi

This should do it:

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

Regards,
Per

"chuck72352" skrev i meddelelsen
...

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(AVER AGE(C4:C8),1))

Thank you,
Chuck


--
chuck72352
------------------------------------------------------------------------
chuck72352's Profile:
http://www.thecodecage.com/forumz/member.php?userid=482
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=113816

Average only if all cells filled
 

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

Since count only detects numbers, ensures that 5 numbers are present before
averaging.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"chuck72352" wrote:


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(AVER AGE(C4:C8),1))

Thank you,
Chuck


--
chuck72352
------------------------------------------------------------------------
chuck72352's Profile: http://www.thecodecage.com/forumz/member.php?userid=482
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113816

Average only if all cells filled
 

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)),"")


--
chuck72352
------------------------------------------------------------------------
chuck72352's Profile: http://www.thecodecage.com/forumz/member.php?userid=482
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113816

Average only if all cells filled
 

see your other post

--
Biff
Microsoft Excel MVP


"chuck72352" wrote in message
...

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(AVER AGE(C4:C8),1))

Thank you,
Chuck


--
chuck72352
------------------------------------------------------------------------
chuck72352's Profile:
http://www.thecodecage.com/forumz/member.php?userid=482
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=113816