View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LauraRose
 
Posts: n/a
Default formula result #value! needs to equal zero for average calculation

the lowdown:

column A and C are start and stop times. column b is the difference,
calculating minutes to a result. If there is is only one value in column A or
C I get the #value! error in column B.

In order to calculate a correct average resolution time I need to those
#value! errors to equal zero so they are disregarded by my average
calculation.

Here is my formula:
=SUM(G2:G128)/COUNTIF(G2:G128,"<0")

Thanks for your help!