The formulas I am using seem to return data that is incorrect (highlighted in yellow) for previous years. For example, there is little information available for the years 2000-2007 but its returning a large number of tracts and footage that are very similar.
I want to think that the formula I am using is pulling data correctly for the more recent years, but now I am unsure. 3-8-11.xlsx
Use this formula in Column-F..
=SUMPRODUCT((((DATA!$B$2:$
Saurabh...