To use Countif, you'll need to specify the range of cells you want to count, as well as the condition you want to apply. Don't worry, it's easier than it sounds! Just remember, the syntax is =Countif(range, criteria), where range is the group of cells you want to count, and criteria is the condition you want to apply.
For example, let's say you have a list of sales data, and you want to count the number of sales that were over $100. You would use the formula =Countif(A1:A10, ">100"), where A1:A10 is the range of cells containing the sales data. Easy peasy, right?
But here's the thing: Countif isn't just limited to numbers. You can also use it to count cells that contain specific text, like a certain word or phrase. Just use the "*" wildcard to match any characters, and you're good to go!
Countif Function How To Use COUNTIF In Excel: Step By Step (+COUNTIFS)
