View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tanya Tanya is offline
external usenet poster
 
Posts: 155
Default Average of only cells containing numeral value

Hi
Can anyone advise me please of a formula to calculate the average for a
range where only numerals are present. i.e. I have a column with a number of
text values in which the numeral value has no entry?
Thank you in advance.

Regards
Tanya