Thread: how to average a range of cells and ignore #div/0! answer
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default how to average a range of cells and ignore #div/0! answer
hi
=IF(A2=0,"",AVERAGE(A2:A10))
or
=IF(A2=0,0,AVERAGE(A2:A10))

adjust range to suit.

Regards
FSt1


"Vince" wrote:

How do I average a range of cells that are blank until data is entered later
with out the destination cell returning a #div/o! error
Reply With QuoteReply With Quote