Thread: How do i get an average that ignores blanks in the range of cells.
View Single Post
  #2   Report Post  
anilsolipuram
 
Posts: n/a
Default

Try this

=SUM(D7:E11)/COUNT(D7:E11)


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=277004

Reply With QuoteReply With Quote