The COUNTIF function, also called COUNTIF in Spanish, is not only found in Excel: it is a very common solution in spreadsheets to count different values based on one or more conditions. The web-based office application Google Sheets also includes this handy feature..
The COUNTIF formula of Google Sheets is very useful, for example, when you want to add date values? In this case, the condition can also be in text format , allowing you to count the times the same name appears in a list or the same product in a general inventory . In accounting , the COUNTIF function of Google Sheets is used to compile the records for the last few months. In this way, you can quickly get an overview of the amounts and invoices received.
The formula to conditionally count values in Google Sheets is as follows:
=CONTAR.SI(intervalo;criterio)
=COUNTIF(intervalo;criterio)
If you have a table where you want to add different values that meet one or more conditions, the COUNTIF function is the perfect option. Once you have this formula ready to use in Google Sheets, the rest of the process will take a matter of minutes. You just have to follow these steps:
Of course, you can also search for the number of invoices with an amount greater than 6000 by entering > instead of < . Also, with the COUNTIF function of Google Sheets you can use the = character and even define two conditions . For example, if the table contains other cells with a value greater than 12,000, you can enter:
=COUNTIF(B2:B500;"<6000";B2:B500;">=12000")
This formula shows you how many invoices are below 6,000 and how many have an amount of 12,000 or more..
If you have noted the date of receipt of the invoice in another row and, for example, you want to know how many invoices were received before 01/31/2020, you can create the corresponding formula with this structure:
=COUNTIF(B2:B5;"<31/1/2020")
Because multiple users can use Google Sheets at the same time , it is possible for multiple employees from different departments to edit the same table, depending on their tasks. For example, the accounting department may want to know how many invoices are still unpaid this month, while the marketing department can use the COUNTIF function of Google Sheets to see how often a type of customer has purchased certain products.