What are some of the specific criteria for Formula One?

Excel 2007, multiple part formula

• I am looking for a formula that will calculate the appreciation or depreciation of a homes value based upon a specific time period where the value can change up or down on a daily basis (typically monthly). I have a two page spreadsheet. Page 1 contains: Two sale dates; Date 1: Subject Date of 01/31/2009. (Say, Page 1, B8) Date 2: Comparable Sale 1 Sale Date, 10/15/2009. (Say, Page 1, D8) Page 1 also contains: The sale price of Comparable Sale 1. Comparable Sale 1, Sale Price $415,000 (Say Page 1, D5) Page 1 also contains: The formula I need. (Say Page 1, D10) Page 2 contains data in Columns A & B. Column A contains an array of daily dates for three years. Say 01/01/2008 through 12/31/2010. Column B contains a daily appreciation or depreciation factor. (This is a yearly factor broken down into a daily factor). This daily factor can change from month to month. Say -12% annual (-1%/-.001) depreciation one month) and 3% annual (3%/.0025) appreciation the next month. (For illustration only). I need a formula that will calculate the number of days between date one and date two; sum the values on page 2 in Column B that are adjacent to "all of the in between dates of date 1 & 2", then divide that sum by the total number of days between date one and date two, then multiply that result by the sale price of Comparable Sale 1. The result is in the formula cell (Page 1, D10) I can get parts of the formula to work but have not been able to figure out how to express it all in one formula. I have managed to get the other formulas I need to work for this project but have spent too much time trying to find this one. Thanks in advance for your assistance. Also, in the very near future, I will need additional assistance and I am willing to pay for the assistance. The whole project is basically an AVM (Automated Valuation Model) for real estate appraisal based upon data derived from the local market. It will be web based and will need: 1) A database of sale comparables that can be searched (based upon specified criteria) and then the sales dropped into thespreadsheet for analysis based upon the various formulas (like this one) producing an estimate a value of the subject property based upon each of the comparable sale's adjustments. Hence, I will need expert assistance in probably FoxPro Database, Web based platform using a database, excel, VB and perhaps more. Can you recommend preferably one person who has the combined ability to assist me in this endeavor? Sincerely, John P.S. Tried using "check Spelling". Message said IE modified page to prevent cross scripting. No allows pop ups or anything else. Page displayed as blank. Tried several times, no other options were available. Finally cut, pasted into Word, did spell check and pasted back here.

• Answer:

  Assume page 2 is named Sheet2 In D10 of page 1 =(sumproduct(--(sheet2!$A$1:$A$1200>$B$8),--(sheet2!$A$1:$A$1200<$D$8),Sheet2!$B$1:$B$1200)/($D$8-$B$8-1))*$D$5 I have excluded the date1 and date2 from the calculation as you said inbetween. I assume data in page 2 is in the range row 1 to row 1200. As long as this includes all the data, that is OK. It doesn't have to refer to exactly the start and end cell (although you can adjust it to refer to the exact ranges). I don't know anyone to recommend for you paid work. sorry.