AVERAGEIF Advanced AVERAGEIF(range, criterion, [average_range]) Returns the average of a range of numbers that meet a given criteriaLearn more AVG Numeric AVG(number1, [number2, ...]) Returns the average (mean) of the provided numbersLearn more ...
Included on this page, you’ll find tutorials on how to use VLOOKUP to compare two criteria columns in Excel, using VLOOKUP with other functions (for example, CHOOSE, SUM, SUMIF, and MATCH), and how to perform a VLOOKUP of multiple files in Google Sheets.In...