View Single Post
  #1   Report Post  
KIM
 
Posts: n/a
Default Averaging numbers but ignoring < and - entries

I have a column of data as illustrated below than contains numbers, blank
cells, dashes and < entries. Is it possible to average only the numbers
ensuring that the divsor is the number of cells that contain number entreis
rather than all cells containing an entry (eg for below example answer should
be 0.137)

0.3

<0.001
0.01

<0.01

0.1

Thank you