Average of numbers that came from another formula

I have a spreadsheet of issues with start and close dates and would like to get an average of how long issues stay open for.

 

Column A: Start Date

Column B: Close Date:

Column C: How long the issues was open using =B2-A2

 

I tried using the average formual but get an error divo.  Is it possible to get an average of numbers that came from a another formula?

By: Julie Leeks

Leave a Reply

Your email address will not be published. Required fields are marked *