COUNTIFS, SUMIFS, and AVERAGEIFS in Real Estate Analysis [Video]

Why use COUNTIFS, SUMIFS, and AVERAGEIFS functions in real estate? When real estate analysts first start their careers, they’re often required to work with large data sets and to transpose property and portfolio information from one format to another in Excel. At first, being unfamiliar with many of Excel’s functions, they manually perform these operations. This increases the time it takes to perform tasks and makes it more likely they’ll commit an error.

Over time, these analysts come to discover the powerful functionality of Excel’s tools and functions that save them valuable time and reduce the chance for error. I’d like share three such functions: the COUNTIFS, SUMIFS, and AVERAGEIFS functions and a few ways to use them in real estate underwriting.

When Will I Use the COUNTIFS, SUMIFS, and AVERAGEIFS Functions?

Much of real estate underwriting and analysisrequirecccccs working with and making sense of large data sets. You, the CRE professional, must analyze rent rolls …