You can count all cells not equal to x or y using a simple COUNTIFS formula. If you only want to count using one condition, then you can also use COUNTIF as an alternative. I’ll explain both in this...
I received a lot of questions on how to use IF function with 3 conditions, so I’ve decided to write an article on this topic. The IF examples described in this article assume that you have a basic...
This step-by-step tutorial shows how to unmerge cells in Excel, how to find all merged cells from a worksheet, and how to fill unmerged cells with the original content of the merged cells. Merged cells provide...
If you are looking to create a breakdown of yearly sales based on a list of transactions you can use the SUMIFS function.
You can use the COUNTIFS function to count the number cells between two dates of an Excel file. Example file included.
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.
Radu