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
Смотрите видео Conditional Weighted Average Formula in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Adventures in CRE 09 Май 2016, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 38,386 раз и оно понравилось 209 людям.