Conditional Weighted Average Formula in Excel
Using the SUMPRODUCT function coupled with the SUMIF function to create a conditional, weighted averaged formula in Excel. Think of this as a WEIGHTEDAVERAGEIF() type function.
00:00 - Introduction
01:00 - Calculating Average Rent
02:10 - Calculating Weighted Average Rent
03:30 - Conditional Weighted Average for Tenant Types
05:20 - Using Conditional Weighted Average with Zeros
06:30 - Conditional Weighted Average with Zeros Explained
This tutorial is based on using this concept in a real estate financial modeling setting, but the method is transferrable to other applications.
To download the Excel workbook used in this video, visit: https://www.adventuresincre.com/condi...
To learn more about the author, visit: htttp://www.spencerburton.org
Watch video Conditional Weighted Average Formula in Excel online without registration, duration hours minute second in high quality. This video was added by user Adventures in CRE 09 May 2016, don't forget to share it with your friends and acquaintances, it has been viewed on our site 38,386 once and liked it 209 people.