View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LilBeanie1033 LilBeanie1033 is offline
external usenet poster
 
Posts: 3
Default zero value cells/blank cells causing error in AVERAGE?

I am attempting to build a running daily score average report based on
several categories that either have a numeric or N/A value. How do I omit
the N/A values from the average? I can't seem to make it stop assigning a
zero value to those cells.