function to count and/or average when data changes daily

[chavez000]

Hi all,

I have a spreadsheet that contains developer related data. I want to be able to do a weekly analysis of average construction time and costs. The problem I am running into is properties enter rehab phase and exit rehab phase throughout the week.

For example:

I want to know the average $ spent and total rehab time week 1 of april. I may have 4 homes that entered rehab that week and 3 that move out of rehab that week. Moreover, I need to ensure those homes that entered and are still in rehab for that week are counted. How do I accomplish this feat?

[Saarang84]

Hi,

For us to provide you solutions, it would be best if we had an workbook with sample data to work with. Can you upload a sample file (with sanitised data)?

[chavez000]

Hi Saarang,

I have attached a sample of the issue. The drop down menu for status is reno, listed and escrow. Once a property is done with renovation, I move it into the next category. Let me know if you can help.