This tutorial came from a recent request on how to calculate the number of room reservations needed each night for an event. I came up with two solutions, one using the IF and AND functions, and the other using COUNTIFS.
In the past we’ve used the combination of INDEX and MATCH to extract the value of the intersection of a row and column of a data range. But there is more that you can do with this function combination, and we’ll look at those options in this tutorial.
In this tutorial we are going to look at how to filter and sum up a column of data that has multiple criteria in both rows and columns using two options – either the SUMPRODUCT function or the SUMIFS function.
In this tutorial we’ll explore how to use the SUMPRODUCT function to divide arrays and add them rather than multiplying those arrays.
In this tutorial we are going to use the MAX and IF functions in an array formula, along with INDEX and MATCH to extract the last date in a list of events that is less than a control date and the event related to that date.
In this tutorial we are going to see how we can create a list of worksheets in our workbook, automatically create a hyperlink to each worksheet and make it dynamic so that when we add or delete any worksheet, the hyperlinked list will automatically update.