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

Have you tried it?

--
Don Guillett
SalesAid Software

"Bob Smith" wrote in message
ink.net...
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