Trying to take the average difference between market values in one metro versus the national average. Both national data and the metro data are in the same data set, so I have been attempting to use multiple criteria in an "AVERAGE(IF(..." format. Cannot use VBA. Current formula is:
Where "MVperSF_SF_Wtd" is the value-weighted market value per square foot for an apartment building. The results are just wrong, so looking for some help.
I have attached the file for further clarity. Please see column "R".
Thanks for the help!!!