This tutorial will present one way to return an average of an Excel range, whilst ignoring blanks, text, errors, as well as excluding the largest…
XIRR formula across multiple sheets
Goal: We want to calculate the respective IRR for each entity on the summary sheet. Each entity contains its own worksheet, thus we need to…
Excel SUMPRODUCT financial modelling examples – part 2
This feature explores further practical applications of Excel SUMPRODUCT. This is a follow-up to an earlier video on uses to the SUMPRODUCT function.
Excel SUMPRODUCT financial modelling examples
This case study will present practical uses of the Excel SUMPRODUCT function. The SUMPRODUCT function is still a viable alternative to SUMIF or SUMIFS.
Average an Excel range – ignoring blank, text or error cells
Download Spreadsheet Vault SpreadsheetVault – AVERAGEIFS ignore blanks, errors or text (solution).xlsb This video will show you one approach to average across blank, text or…
Excel SUMPRODUCT in Business Planning
The Excel SUMPRODUCT function is one of the more flexible, powerful and practical tools to compute numbers in business planning. The length and breadth of Excel SUMPRODUCT speaks for itself. This article and video will identify its value in business planning, to perform both aggregation and multiplication of financial variables in a financial model.