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

The countifs 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. We can use many criteria in this function, multiple conditions with this formula.

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 countifs function in Excel or actually how can you use the countifs 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