Thread: How do I average a group of cells and ignore a #div/0! error?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scott R[_2_] Scott R[_2_] is offline
external usenet poster
  
Posts: 6
Default How do I average a group of cells and ignore a #div/0! error?
Him You Them Us Me
12 10 8 6
12 11 7 4
11 9 6 9
average 11.6 10 7 6.3 #DIV/0!

How can you average the cells in the bottom row and ignore the #div/0! Error
to get the answer 8.76?

Reply With QuoteReply With Quote