The SUMIF function adds cells specified in range by a certain condition or criteria.

VLOOKUP in excel stands for vertical lookup. This simple function is extremely useful if you have large lists of data. With this function, you can easily search through a list of data and match specific criteria. In the example below, we will use this function to match a batting average with a specific player.

There are various methods used to count cells in Excel. We will be utilizing the COUNT function.