View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bk_412 bk_412 is offline
external usenet poster
 
Posts: 1
Default How do i get an average with #div/0! in a cell

I am looking to get an average from like c9:l9. Those cells are linked to
other worksheet averages. They sometime have #div/0! in it. I am loooking to
ignore that part and just get the average of numbers in those cells.

Any help would be appreciated

regards,

BK