View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Graham Graham is offline
external usenet poster
 
Posts: 155
Default Calculating Average

I am trying to calculate teh average of a column without counting blanks. How
can I do this? My current formula is =AVERAGE(X8:X26) but is counting blanks
in it. In that column, I have formulas to enter in the number needed...is
this a problem? Thanks for your help. Graham