Thread: Calculating the average
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andy_Trow Andy_Trow is offline
external usenet poster
  
Posts: 8
Default Calculating the average
I have a range of cells

A1:A10
In each of the cells there can be a number from 1 to 5 or an X
In Cell A12 I want to display the average of all the numbers in A1:A10
Reply With QuoteReply With Quote