Counting cells that equal to a specific value can be achieved using COUNTIF function. If you need to use multiple criteria you can also use COUNTIFS.
Category - Excel formulas
RaduHow to change case in Excel to UPPER, lower or Proper
Learn how to change text case to UPPER, lower or Proper format and combine text from different cells to obtain the desired result.
Sum sales by year using SUMIFS
If you are looking to create a breakdown of yearly sales based on a list of transactions you can use the SUMIFS function.
Count cells between two dates using COUNTIFS
You can use the COUNTIFS function to count the number cells between two dates of an Excel file. Example file included.
Identify VAT rate based on country using VLOOKUP
To identify a VAT rate based on a simple tax rate table, you can use the VLOOKUP function. For this example we have also used a Data Validation List.
