View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alin Stanciu Alin Stanciu is offline
external usenet poster
 
Posts: 2
Default Average with #div

Hello.
I need to make an average but some of the cells in range contain#div because
they are not completed with data in range in order to make my average
function work.
What i need i a formula which calculates the average of the cells with
content, but ignores the ones with #div.
Thank you!