Tag: averageif

  • Excel: Looking up data

    This time, I show you how I look up data in a table using the XLOOKUP function.

  • Excel: Find average based on multiple criteria

    Last week, I showed you how to find an average based on a single criterion. That works well enough, but what if you want to find an average based on multiple criteria? In that case, the AVERAGEIF-function will fall short. In its place, you must use the AVERAGEIFS-function. This time, we want to find the…