Use VLOOKUP when you need to find things in a table or range by row.
COUNTIF function
Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 More...
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.
IF function
Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect.
SUMIF
Excel for Office 365 Excel 2019 Excel 2016
Use the SUMIF function to sum the values in a range that meet criteria that you specify.
By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.
Combine text from two or more cells into one cell
Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 More...
You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.
