Function: VLOOKUP

Function: VLOOKUP

VLOOKUP function is a lookup and reference function that can search a specific information in a table. In this guide, we’re going to show you how to use the VLOOKUP function and also add some tips and error handling methods.The VLOOKUP searches a value in...

Function: AVERAGEIFS

Function: AVERAGEIFS

AVERAGIFS function can calculate the average in a range of cells, based on a criteria. In this guide, we’re going to show you how to use the AVERAGIFS function and go through some examples, as well as error handling methods. Supported versions (Windows)...

Function: COUNTIFS

Function: COUNTIFS

COUNTIFS function can count the values in a range of cells, based on some criteria. In this guide, we’re going to show you how to use the COUNTIFS function and cover some examples and error handling methods. Supported versions (Windows) Excel 2007 and above (Mac)...

Function: SUMIFS

Function: SUMIFS

SUMIFS function can sum up the values in a range of cells, based on some criteria. In this guide, we’re going to show you how to use the SUMIFS function and cover some examples and error handling methods. Supported versions (Windows) Excel 2007 and above...