Countif excel4/7/2024 ![]() ![]() The COUNTIF function allows you to reference other cells containing the values or the criteria.įor example, let us assume that the qualifying age for a certain activity is available in cell C3 as shown bwlow. To count people who have the name “Andy”, type =COUNTIF(A3:A11,”Andy”) and hit the enter key. Similarly, you can use the formula =COUNTIF(B3:B11,”<18″) to count people who are younger than 18 years of age.ģ. To count people who are older than 18 years, type =COUNTIF(B3:B11,”>18″) and hit the enter key. ![]() Tip: Instead of typing B3:B11, it far more easier to select the range B3:B11 using the mouse.Ģ. In above example B2 to B11 is the ‘Range’ of cells to Count and 18 (Age) is the Criteria. ![]() To count number of people who are exactly 18 years of age, type =COUNTIF(B3:B11,18) and hit the enter key on the keyboard of your computer. The COUNTIF Function can be used to count people who are above 18 years, below 18 years and those who are exactly 18 years old.ġ. Let us assume that you have an Excel worksheet with Names of people in Column A and their Ages in Column B. Now that you understand the Syntax of COUNTIF Function in Excel, we can take a look at some examples to understand the actual usage of COUNTIF Function. Criteria: The condition that defines the cells to be counted.ġ.The Syntax of COUNTIF Function is COUNTIF (range, criteria) The COUNTIF Function supports logical operators (=, ) and wildcards (*,?) for counting cells matching partial criteria. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |