In this Google Sheets Excel video tutorial, we gonna see how to Countif in Google Sheets to Solve a Real Problem with Practical Example.

The countif function is a formula that allow us to count, not everything that we having in a range, but just the things that match with a certain criteria.

So anything that match with a criteria is going to be counted. Let's say you have a sales report with the date, the order ID, the region name, the total sold etc., and you want to know the total of orders that you have. You can simply use the count function to help you and count everything that you have within the order id range or count all the values that makeup the order ID column.

however let's say now we want to make him more specific analysis and you need to know how many orders you have to I specific region that way you're going to need to use the count formula but with a criteria with a condition and the condition here in this situation is going to be the region name so you going to count with a criteria we're going to count if the condition is met.

This is how you can use the countif function in Excel or actually how can you use the countif formula in GoogleSheets. This formula is very important because it's can also help us to automate tasks and to save time whenever you we are using a spreadsheets.

#JopaExcel #Dashboard #Excel