Still Manual? Learn the Functions Used to Count Many Data in a Specific Range in a Spreadsheet

Functions used to calculate many data in a certain range (freepik)

YOGYAKARTA - Often having trouble calculating large amounts of data in a spreadsheet? Don't waste any more time with manual methods that are prone to errors. Learn the functions used to calculate large amounts of data in a specific range to make your work faster and more accurate!

This function is an automation solution that all Excel or Google Sheets users must master. By mastering this technique, you can filter and calculate complex data based on specific criteria without manual input. Summarized from the Medan Area University Computer Center page, the following are the important points:

What Function is Used to Count Many Data in a Specific Range? Function to Count Data with One Criteria (COUNTIF)

The main function you are looking for is COUNTIF. This function is used to count the number of cells within a range that meet one specific criteria. It is a quick solution to replace manual counting.

The systematics or syntax of the formula is: =COUNTIF(range, criteria)range: The area or range of cells whose data will be counted.criteria: Criteria, conditions, or expressions that will be tested on the range.

Example of use:

Count the number of texts "AKU" in the range A2:A10: = COUNTIF(A2:A10, "AKU")Criteria More than One, Use COUNTIFS!

If you need to count data based on multiple criteria at once (nested COUNTIF), use the COUNTIFS function. This function will count cells only if all criteria you specify are met.

The mathematical syntax is: =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)criteria_range1: The first range to be tested.criteria1: Criteria for the first range.[criteria_range2, criteria2]: Pair of ranges and criteria second, third, and so on (optional).

Example Usage: For example, you want to count how many "Women" (column B) have the hobby "Cooking" (column C) from the data in rows 2 through 11. =COUNTIFS(B2:B11,"p",C2:C11,"cooking")

NOTE: The use of commas (,) or semicolon (;) in the formula, if (,) is not successful, try replacing it with (;).

Read also the article Students Must Know! Here is the Best Indonesian Translate App to English

What is the Difference Between COUNTIF and Other Count Functions?

Don't confuse COUNTIF with other COUNT functions. Each has specific uses, including:

COUNT: Only counts cells that contain numeric data. COUNTA: Counts all cells that are not empty (contain numeric or text data). COUNTBLANK: The opposite, this function counts the number of cells that are empty or not filled with data at all. COUNTIF/COUNTIFS: The only one that counts cells based on specific criteria or conditions that you specify.

Now it is clear that the function used to count many data in a certain range based on criteria is COUNTIF (for one criterion) and COUNTIFS (for many criteria).

Mastering these two functions will save you time, reduce the risk of manual calculation errors, and make your reports much more accurate and professional.

In addition to discussing the functions used to calculate many data in a certain range, follow other interesting articles at VOI, to get the latest news, don't forget to follow and monitor all our social media accounts!