We apply both the function on the given data. Comparing to complex array formulas, it may be much easier to save all filtered records into a new worksheet, and then apply the Count function to count the filtered data range or list. . To count numbers and text, use the COUNTA function. สูตร COUNT จะนับเฉพาะตัวเลข รวมไปถึงวันที่ เวลา ด้วยนะ. The name should not have spaces. COUNT and D_COUNT, distinct counts, are ways of aggregating data. The COUNTA function counts the number of cells that are not empty in a range. This behavior is controlled by the preference "Use table names in formulas". Click on the Statistics command in the Number Column section. Check and select Count unique values in the Choose a formula box. Step 3: Now, click on “Options>>. Count the Rows with the Non-Blank Cell. CountA Formula in ExcelHow to Calculate count by CountACountA Function in Exc. If you are looking for a simple solution to calculate the percentage of completion in a quick way then you are at the right place. The group of cells you want to count. To count empty cells, use the COUNTBLANK function. STEP 3: In the Create PivotTable dialog box, Excel will automatically select the table for you and the default location will be New Worksheet. Here are two methods of doing this: METHOD 1: Using COUNTIFS function. Hit enter. ”. The syntax of the Excel COUNT function is as follows: COUNT (value1, [value2],. 2. Re: Difference between the SUBTOTAL (103) and COUNTA? COUNTA counts the number of cells in a range that are not empty and returns that number. COUNT will return the number of cells that contain numbers, whereas COUNTA. Generally, this result is displayed in a cell to the right for a horizontal range or in a cell below for a vertical range. Q&A for work. For use of filtering the Data in the later columns, we currently use a helper column in A consisting of the running count of the duplicates in A with a formula using semi-anchored ranges(ie. This function includes empty text ("") in the count. Using the example above, you can count records where the color is. INDEX, MATCH, and COUNTIF Functions with Multiple Criteria: 4 Easy Ways. Find out the difference and try to apply it in your work. For example, SUM is an aggregation where the listed values are added together. COUNT and COUNTA are identical in DAX for all the data types except Boolean. The COUNTIF and COUNTIFS functions count cells. Select “COUNTA” from the drop-down menu. To count non-blank cells, use cell references or ranges. Remarks. Criteria can include logical operators (>,Supposing you have a column of names in your Excel worksheet, and you need to count unique names in that column. Steps:Select the cell range B2:B10 and enter “Shop_B” on the Name Box. COUNTA is useful when you need to determine the total number of non-empty cells, regardless of their content. This creates a list of the unique district names, with 1 entry for each. 20. Type * in the Find what field under the Find tab. To count numbers or dates that meet a single condition (such as equal to, greater than, less than, greater than or equal to, or less than or equal to), use the COUNTIF function. 2: count numeric values. =COUNTIF (B2:B15,”Y”) The COUNTIF formula returns the count of an employee who has received funds, i. Learn about the difference between COUNT and COUNTA functions in Excel 2016 - Office 365COUNT function counts all numeric cells in the range and COUNTA funct. The COUNTA function is a premade function in Excel, which counts all cells in a range that has values, both numbers and letters. Select the cell where you want to display the result. Range ("A2") = WorksheetFunction End Sub. You can extract the distinct values from a list using the Advanced Filter dialog box and use the ROWS function to count the unique values. Steps: First of all, select a cell where you want to find out the Total Price of Glass. 8. Does not support Logical values (TRUE/FALSE values). COUNT and D_COUNT, distinct counts, are ways of aggregating data. Excel COUNTIF Function. Funkcia COUNTA spočíta bunky obsahujúce ľubovoľný typ informácií, vrátane chybových hodnôt a prázdneho textu ( "" ). 1. The group of cells you want to count. Enter the following formula in cell E3: =COUNTIF (B2:B9,"Yes") Here’s the result we get: Note: The COUNTIF function is case-insensitive. COUNT FUNCTION can be used when we want to count. The Excel COUNTIF function returns the count of cells in a range that meet a single condition. =IF (C4="Fruit",1,0)Select the cell where you want to see the result, the actual count. COUNTIF is a simpler function if you only need a single check. You can use the following steps to write the formula: First, type =COUNTIF ( in cell B1 to start entering the function in the cell where you want to get the result. We can type the following formula into cell D2 to calculate this number: =COUNTIFS (A2:A16, "Guard", B2:B16, "<>"&"") The following screenshot shows how to use this formula in practice: The formula returns a value of 5. To count numbers and text, use the COUNTA function. Go to the Transform tab. To see a function evaluated step by step, select the cell containing the formula, and then on the Formulas tab, in the Formula Auditing group, click Evaluate Formula . Return value. This tells us that there are 5 players with a value of “Guard” in the Position column where the corresponding value in. Since only three of the four cells in the range contain data, the formula calculates the percentage of yes responses out of three. Using the COUNTA function in Excel you can count non blank cells in Excel in Column A, Product Codes. Select a range. COUNTIFS function can handle multiple criteria as arguments and counts the cells only when all the criteria are TRUE. How to Count the Number of Multiple Values. The formula will count the total number of non-empty cells within the specified range (s). In the example below, COUNTA returns a value of 6 non-empty cells since it counts. In the example shown, the formula in C11 is: =SUMPRODUCT((LEN(B5:B8)-LEN(SUBSTITUTE(B5:B8,C2,"")))/LEN(C2)) Note: The formula on this page counts. Được sử dụng bởi: Được sử dụng cho các sổ đăng ký và mục đích bảo trì hồ sơ liên quan đến thời gian và ngày tháng. ]) value1 – the value or range of cell (s) to count within. But, it will not happen in the case of the COUNTA() function. Ak nepotrebujete do výpočtu zahrnúť logické. To count the number of unique values in a range of cells, you can use a formula based on the COUNTIF and SUMPRODUCT functions. Type in the formula: = COUNTIF ( E2:E5, "Yes" )/COUNTA ( E2:E5 ); The answer 67% should appear in cell E6. . COUNTA does not count empty cells. Two out of three responses are yes, which is equal to 67%. . For more information on array formulas, see Guidelines and examples of array formulas . Ali Enthusiastic self-taught user of MS Excel who's always learning! Don't forget to say "thank you" in your thread to anyone who has offered you help. If you want a more general solution, where you want to count all uppercase or all lowercase letters, you could use something like this: Uppercase formula:. 3. Right-click the Status Bar, and select “Numerical Count” to place a checkmark next to it. This example counts cells in B2 through D6, and in B9 through D13. Step 1: In Excel, enter the data as shown in the following image. Learn COUNT, COUNTA, COUNTBLANK AND COUNTIF Function with easy example and also identify difference between COUNT AND COUNTAEntering the COUNTIF — COUNTA Formula. Second condition is Product : Carrot. 비교적 쉽고 인지하기 함수라 함수마법사까지 사용안하셔도 될듯 하고. Click the Sum button in the Editing section of the. Select the Duplicate Values option from the submenu options. Excel 2016 tutorial on how to count the number of cells in a range that contain numbers using the COUNT function, and how to count the number of cells in a r. So unlike the COUNT function, which considers only numbers, COUNTA considers numbers, dates, text values, logical values, and errors. " This places a filter button (arrow) next to each column header. Empty C7 and C8, as in the case with. g. 1. -- COUNTX can be expressed in a more explicit way by using CALCULATE. How to use the =COUNTA function: Select a cell. If COUNTA is your function of choice, you don't need to add 1, since this function counts all non-empty. We could modify the formula that counts the number of students taking Math to include Jason and Chris as follows: =COUNTA (C2:C7,"Jason","Chris") Result: 5 'Number of students with a grade in Math + Jason + Chris. Learn how to use the COUNTA function in Microsoft Excel. 2. After that, Excel. Enter the following formula. Counting responses. . Function COLORCOUNT (CountRange As Range, FillCell As Range) Dim FillColor As Integer Dim Count As Integer FillColor = FillCell. 2. Sum. COUNTA works in a similar way. Cells A2 to A8 have text values which can only be counted using the COUNTA Google Sheets function. In B column, some data is numeric, some data is alphabetic and some cells are blank. The CHOOSE function will allow us to return a value from a list of values based on a selected index number. Les deux fonctions fonctionnent de la même manière, mais il y a une différence majeure dans le fait que vous devez savoir les utiliser de manière optimale. Hence, we need to store it in a cell, i. Click OK after entering both range & criteria arguments. COUNTA Function : It is used to count number of non-blank cells in a specified range of cells. So a formula that appears to have no output will instead output. In this example, if. Use AutoSum by selecting a range of cells that contains at least one numeric value. > > I have a spreadsheet with a list of doctors names and other > information, I tried to do a count on the column using the. The COUNT function internally executes COUNTX, without any performance difference. We can use the COUNTIF function in this case, to count the number of cells in the range B2:B9 that contain the text “ yes ”. It is typed =COUNTA. The result is 3. criteria (required). Step 1: Here, there is a mixed list of data that has different values and a few blank cells, in between, and we want to use the COUNTBLANK function in order to determine the number of blank cells in the range. . This can be a number (between 1 and 254), a cell reference, or. To count these values with a dynamic reference, you can use a formula like this: =COUNTA(D5#) The hash character (#) tells Excel to refer to the spill range created by UNIQUE. In this section, we will explain the step-by-step process of how to use SUBTOTAL with COUNTIF in Excel. You can use the following formulas to count the number of “Yes” and “No” values in a particular range in Excel: Formula 1: Count Number of “Yes” Values =COUNTIF(B2:B21, "Yes") Formula 2: Count Number of “No” Values. A number, expression, cell reference, or text string that determines which cells will be. Dates. The easiest way to count cells that have one value or another (Countif a or b) is to write a regular COUNTIF formula to count each item individually, and then add the results: COUNTIF ( range, criterion1) + COUNTIF ( range, criterion2) As an example, let's find out how many cells in column A contain either. The COUNTA function is also commonly referred to as the Excel COUNTIF Not Blank formula. COUNTIF Function. In the formula bar, the structured reference [@. COUNTIF is a very simple function. COUNTA takes multiple arguments in the form value1, value2, value3, etc. After that, in the second argument, refer to the range A1:A101. COUNTIF counts how many cells in a range meet a certain condition. Funcția COUNTA contorizează celule care conțin orice tip de informații, inclusiv valori de eroare și text gol ( „” ). Observații. Select your table of data. This means you can use COUNTA as a simple way to count cells that are not blank. I have used sumproduct for the teams and profession but i don't know how to add the counta section at the add. We want to find out the Total Price of the Glass using the SUMIF function. The number 27 in cell A5 was entered as text — as. If the cell range you want to count contains blanks, those will be included as unique values which may cause a problem. So, select the range and press delete, and you should be brought back to zero. In Excel, to count a specific character, you need to use a combination of SUBSTITUTE and LEN functions. COUNT comes from Excel and will count the number of cells in a column that contain a number. Select your column header and go to the Home tab. Cho một bảng danh sách thống kê tình trạng nộp bài của sinh viên như hình minh họa dưới. This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules. 📌 Steps:. Excel returns the count of the numeric values in the range in a cell adjacent to the range you selected. This is the range from which you want to count the non-blank cells. Once you. Then it would add 2 more because of the 2 value. SUBTOTAL gives a "total" of the cells in a range that have a numeric value, including 0 then dividing that number by the number of cells in the range that contain a numeric value. Example 2. Make sure the My table has headers box is checked, and click OK. Function Get ColourCount (CountRange As Range, CountColor As Range) Step 4: Now, you can close the VB editor and you will get the result you need, being able to easily count all the colored cells in MS Excel. ”. 이상으로 엑셀함수 정리 해 봤는데요. =COUNTBLANK (B2:F12) You should then see the number of empty cells in the range you selected for the formula. 1. The difference between them is that COUNT only counts cells containing numbers but COUNTA counts all cells that aren’t empty. Both of the functions work in the same way, but there’s one major difference in that you need to know to use them in a better way. Using Excel Menu. When you select your cell range, simply look at the Status Bar, and you’ll see “Numerical Count. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). All good so far. The Excel COUNTA function is a built in function that is used as a relatively simple formula to count the number of cells that are not empty – containing numbers, text, strings in general, TRUE and so on. DCOUNTA counts numbers and text in a given field when criteria match. A number, expression, cell reference, or text string that determines which cells will be. Example 1: The following illustration returns the number of integer values in a given range. Generally, this result is displayed in a cell to the right for a horizontal range or in a cell below for a vertical range. Data aggregation is the process of combining a list of items into one data point. The COUNTA function counts cells containing any type of information, including error values and empty text ( "" ). Example. We will use it to count all nonblank cells. A database is a list of related data in which rows of related information are records, and columns of data are fields. For Example:-COUNTIF Function: It is used to count the number of cells based on a specified condition. Excel 365 formula in cell G3:Observații. The COUNTA function returns the count of values in the list of supplied arguments. Click on the “Options” button to expand the dialog box and show more options. In this example I have chosen 3 (COUNTA) which simply counts entries in non blank cells in the range. Note: visit our page about the COUNTIF function for many more examples. In either the result cell or the formula bar, type the formula and press Enter, like so: =COUNTA (B2:B6) You can also count the cells in more than one range. Where the parameters, value1, [value2], etc. Criteria 2. With the COUNTIFS function, you can count the values that meet any criteria that you specify. ) So COUNTA will count all non-blank cells within a range and will tell us exactly how many cells have data. 3: count dates. So, this section returns 15. Press the OK button. Notes. Excel COUNTIFS Function to Count Filter Data with Criteria by Adding a Helper Column. The COUNTA function counts the number of cells in a range that are not empty. Select the cell where you want to see the result, the actual. Say we wanted to count the number of times Dave. Type in the formula: = COUNTIF ( E2:E5, "Yes" )/COUNTA ( E2:E5 ); The answer 67% should appear in cell E6. This is the reason for the COUNT function not working in Excel. Funcția COUNTA nu contorizează celule goale. COUNT can handle up to 255 arguments. Description. Understanding the Excel COUNT Function. , 8 from the dataset range ( B2:B15 ). COUNTA function: The purpose of the COUNTA function is to count the cells ignoring all blank cells. The first row of the list contains labels for each column. We get 3 as the result, as shown below: The COUNT function is fully programmed. Vì vậy trước tiên, Học Excel Online sẽ phân tích về hai hàm này, và sau đó đưa. It can include Dates, Numbers, and Texts. Funkcia COUNTA nepočíta prázdne bunky. Now, we must click on the “Format” option. Then on the Formulas tab, click AutoSum > Count Numbers. Cả hai hàm này đều rất đơn giản và dễ sử dụng. Dates and times are considered numbers in Google Sheets, which is why the data in cells B4 and B5 is counted by both functions. Rows - to calculate the number of rows to offset, you use either the COUNT or COUNTA function. Unlike COUNT, COUNTA supports Boolean data type. To count with one condition, use the COUNTIF function; To count with multiple conditions, use the COUNTIFS function. can be any values or authority to cell ranges. Two ways to count entries in Excel: COUNT vs COUNTA Usually we think of adding numbers on a spreadsheet, but sometimes you just need to count the items in. Using COUNTA for Multiple Range of Cells in Excel. You can reward them by clicking on * Add Reputation below their user name on the left, if you wish. When we apply COUNT() function to count the cells, excel will return 0. To sum cells based on one. Excel CountA function is often used to Count how many ce. Excel returns the count of the numeric values in the range in a cell adjacent to the range you selected. Find my whole Excel playlist here: Learn how to use two simple functions that can help you generate important information in Excel:. The COUNTA syntax is simply: =COUNTA(value1, [value2],. Select the column you want to count. Note, this formula uses COUNTIF twice since there are. You will not (yet) find COUNTX in Excel. Types: Currently, three types of COUNT functions exist in Excel: COUNTA, COUNTBLANK and COUNTIF. . This tutorial demonstrates how to use Excel COUNTA with our easy to follow examples and takes you st. Note: The COUNT function only counts cells with numbers, not cells with letters. Then, we will select Filter within the Sort. Method #2 – Using COUNTA Function. IN cell D12, type “= CountBlank (” and then select the range of data amongst which you want to find blanks. The syntax of COUNTA Excel function is; =COUNTA (value1, [value2],. Microsoft Excel cung cấp một vài chức năng đặc biệt để đếm các ô: hàm COUNT và hàm COUNTA. =SUM (Y7+Y26+Y44)/COUNTA (Y7+Y26+Y44) Using the table below, I want to add the grapes for three stores, using the above formula gives me 30. When the function does not find any rows to count, the function returns a blank. Forum Rules (updated August 2023): please read them here. Contrarily, this function does not require this argument. The COUNTA function counts cells that contain values, including numbers, text, logicals, errors, and empty text (""). Now, in the first argument, select function_num COUNTA or enter 3. In B column, some data is numeric, some data is alphabetic and some cells are blank. You can use the following formula to combine the SUBTOTAL and COUNTIF functions in Excel: =SUMPRODUCT (SUBTOTAL (3,OFFSET (B2:B11,ROW (B2:B11)-ROW (B2),0,1)),-- (B2:B11="Guard")) This particular formula allows you to count the number of cells in the range B2:B11 equal to “Guard” even after that range of cells has been filtered. Follow the steps below: Steps: In cell D4, write the following formula. For example, if the range contains three cells containing numbers, the result is 3. The Excel DCOUNTA function counts matching records in a database using a specified field and criteria. Just add a calculated field with a formula to evaluate whether the cell has a valid value in it. Let’s translate it into English now by applying it to an example. Kutools for Excel’s Split Data utility can help Excel users easily split a range to multiple worksheets based on criteria in one column of original range. The COUNT FUNCTION returns the result as 5 and COUNTA FUNCTION returns the result as 19 which testifies our statement. Note: To use the COUNTA function, select the range of cells you want to count. Excel returns a value of 4 because cell A5 is empty. COUNTA counts all values in a dataset, including those which appear more than once and text values (including zero-length strings and whitespace). We will cover: The Excel COUNTA. You can see that the input parameters can take many forms: a number, text within double quotes, and a reference to a range of cells The most basic form. learn more about COUNTA here. The COUNTIFS function requires only two arguments, but can handle many more optional criteria. To get started, open your workbook and head to the sheet you want to use in Excel. This is because unlike COUNT and COUNTA, the COUNTBLANK function cannot handle non-contiguous ranges. =IF (C4="Fruit",1,0) Select the cell where you want to see the result, the actual count. Another quirk of the spreadsheet is that when a cell needs to present as empty, I have the value ="". COUNTBLANK() vs. STEP 1: Select the Data Table. Notes. Whenever the function finds no rows to aggregate, the function returns a blank. Re: Combine the VLookup and countA formulas in Microsoft Exc It sounds like this could be solved with COUNTIF. The COUNTA Function in Excel. Re: Combine the VLookup and countA formulas in Microsoft Exc It sounds like this could be solved with COUNTIF. COUNTIF Function. You could do it within the pivot table itself. Blank values are skipped, if data type is Int. To count with one condition, use the COUNTIF function; To count with multiple conditions, use the COUNTIFS function. At the very beginning, select cells in the D16:D17 range. Learn COUNT, COUNTA, COUNTBLANK AND COUNTIF Function with easy example and also identify difference between COUNT AND COUNTA Entering the COUNTIF — COUNTA Formula. Height and width are generated on the fly by using COUNTA, which makes the the resulting reference dynamic. COUNT VS COUNTA RESULTS. . Biên tập bởi Nguyễn Xuân Hòa Đăng 1 năm trước 165. Click the cell where you want to place your data in the cell type =DCOUNTA, then. It means 8 employees have received funds. COUNT () COUNTA () และ COUNTBLANK () ใน Excel 2010. The COUNT function is useful for counting the number of cells. ; After that, click. COUNTA é uma função de planilha estatística que analisa os dados que você deseja contar para facilitar a separação e compreensão das linhas ou células em branco. Example 2: The following illustration count integer Values in the range A1: A4 and B1:B2. If you enter any number data later in these cells, the counting cell will. COUNTA takes multiple arguments in the form value1, value2, value3, etc. Ali Enthusiastic self-taught user of MS Excel who's always learning! Don't forget to say "thank you" in your thread to anyone who has offered you help. Let's call that the result cell. . Description. COUNTA counts how many populated cells in a range (i. COUNTA, on the other hand, is used to count the number of cells that are not empty, meaning they contain any type of data, including numbers, text, logical values, errors, and even empty text strings. The number of non-blank cells in the range B2:B21 appear in cell C2. COUNTA also counts cells with the empty string (""), even though they have a length of zero. . Messages. In under 10 minutes, learn how to write exc. Merging does not impact this. The only thing not counted by the COUNTA function are cells that have absolutely no information. In the above syntax, DAX COUNTA is the function name, and column is the name of the column containing the values to be counted. ) The COUNTA function syntax has the following arguments: value1 Required. 442. COUNTX: Counts the number of values which result from evaluating an expression. Now, we must click on the “Format” option. To count empty cells, use the COUNTBLANK. COUNT FUNCTION can be. The COUNTA function counts cells containing any type of information, including error values and empty text (""). Find my whole Excel playlist here: Learn how to use two simple functions that can help you generate important information in Excel:. Excel Tips and Tricks: COUNT | COUNTA | COUNTBLANK | COUNTIF | COUNTIFS COUNT: Counts the number of cells in a range that contain numbers COUNTA: Counts the number of. COUNTA: Counts the number of values in a column. Type the following formula into the cell replacing the cell range with your own and hit Enter. Microsoft Excel. The COUNTA function is a premade function in Excel, which counts all cells in a range that has values, both numbers and letters. In this section, we will use the DCOUNTA function to count how many persons in the table LastName is Johnson. The functions take into account only the leftmost cell of the merged range. The COUNTA function internally executes COUNTAX, without any performance difference. . To count, choose a cell and enter the COUNT syntax: = COUNT (Range). Type =COUNT. Here's a generic Excel formula to count number of cells containing specific text: COUNTIF (range, " text ") The following example shows it in action. Here, I am gonna show you a simple way to apply the COUNTA function. 엑셀을 활용하여 데이터를 세야 하는데 어떤 함수를 써야 할지 모르겠다! 하시면 이것만 기억해주시면 될 것 같습니다. ; Then, go to the Home tab. After that, you can again count the total characters and compare them with the original count to get the. In this video, you can learn the Difference between the Count v/s Counta formula in Excel. corresponds to the following COUNTAX. Click Field Settings. Use COUNTA when you require the total count of non-empty. Select a range. Formula 1. Syntax. In this example, we will compare the usage of COUNT and COUNTA functions on a sample dataset. You cannot apply multiple conditions with these functions directly. This section will discuss the different count functions available to make your work in Excel more efficient. Steps: First of all, select a cell where you want to find out the Total Price of Glass. Data aggregation is the process of combining a list of items into one data point. Suppose we are given the data below: As seen above, the COUNTA function will count text or formula errors. Syntax. In Excel, the COUNT and COUNTA functions both count the number of cells in a range, but they use slightly different behaviors: The COUNT function counts the number of cells in a range that contain numbers. You can use the following formula to combine the SUBTOTAL and COUNTIF functions in Excel: =SUMPRODUCT (SUBTOTAL (3,OFFSET (B2:B11,ROW (B2:B11)-ROW (B2),0,1)),-- (B2:B11="Guard")) This particular formula allows you to count the number of cells in the range B2:B11 equal to “Guard” even after that range of cells has been filtered. Go to the cell where you want to display the result of the formula. But scroll down to the bottom. COUNTA, on the other hand, is used to count the number of cells that are not empty, meaning they contain any type of data, including numbers, text, logical values, errors,. I need the answer to be 15, one store doesn't have any grapes. The goal is to calculate the percent complete for the project by showing the ratio of complete tasks to total tasks, expressed as a percentage. Make the appropriate filters to columns B & C and the formula will only count the number of entries returned. There are about 30. Here, you might have guessed it right. Used By: Used for registers and record maintenance purposes dealing with time and dates. The table below shows 10 rows with 6 numeric codes, 2 non-numeric codes, and 2 blank cells. Step 3: Now, click on “Options>>. To count unique values, use COUNTUNIQUE. Excel 2016 tutorial on how to count the number of cells in a range that contain numbers using the COUNT function, and how to count the number of cells in a r. Select the Highlight Cells Rules option. Go to Data > Sort & Filter > Advanced. Using A Data Model with A Pivot Table to Count Unique ValuesWhen we apply COUNT() function to count the cells, excel will return 0. 2. Syntax. However, the COUNT function is used to count the number of cells that contain numeric values whereas COUNTA is used to count all the cells in a range that are not empty, regardless of what they contain. COUNTA is fully automatic, so there is nothing to configure. However, Excel doesn't like that formula. First condition is City : Boston. Countrows, count, countA, and a new one called distinctcount which is really, really helpful. . 2. The COUNTA function can count cells containing several types of data values. The criteria can be in the form of a number, expression, cell reference, or text that define which cells shall be counted. Imagine if you have rows and rows of data and you need a quick count.