View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EllenM EllenM is offline
external usenet poster
 
Posts: 78
Default Eliminate negative numbers from stats

Hello,
I am tracking days for project completions. I do this my subtracting the
start date from the completion date. The days of the uncompleted projects
are negative numbers. Among other stats, I'd like to do averages on
completed tasks. What's the best way to eliminate the negative numbers from
the averages?


Could this be done with a pivot table? I know a pivot table would do a lot
of what I'd like done.

Thanks for your help,
Ellen