View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Smith
 
Posts: n/a
Default Need to exclude certain cells in a range

This should be a simple fix, but I'm not having any luck right now figuring
it out.

Need some help to exclude cells within a range of cells. Am doing an average
of 50 cells, =AVERAGE(A4:A53). Some of these cells include an asterisk and
should not be included in the final average.

TIA,

Bob