Thread: Average only if all cells filled
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chuck72352 chuck72352 is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote