To count how many times a specific a word (or any substring) appears inside a range of cells, you can use a formula based on the SUBSTITUTE, LEN, and SUMPRODUCT functions. 2. COUNT will return the number of cells that contain numbers, whereas COUNTA. 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. criteria (required). Or you can select multiple column headers (or row headers). The same result can be achieved by subtracting one Countif formula from another. Although you can use COUNTA to generate the number of clients or employees in a list, it counts each entry, not unique entries. COUNTAX: Counts the number of values which result from evaluating an expression for each row of a table. =COUNTA (value1, [value2,. =SUBTOTAL (3,D2:D10) The syntax is: =SUBTOTAL (TYPE OF TOTAL, RANGE OF CELLS) The same principle applies to the others, find the. To apply this method to your work, you can simply follow the steps below. You can use the COUNTA function in Excel to count the number of cells in a range that are not empty. As you can see, the main difference between COUNT and COUNTA functions is that COUNT only counts cells that contain numeric values, while COUNTA counts any cell that contains any value, including text, logical values, and errors. If you have any blank values within a range of values, the COUNTA formula will exclude all those cells and return a count of the populated cells. Step 3: Now, click on “Options>>. Step 1: Start the sub-procedure by naming the macro. Click the one for the column of colored cells you want to count and move your cursor to "Filter by Color. 1. Select cell B1, enter the formula =COUNTA (A1:A5), and press “ Enter ”. The COUNTA function returns the count of values in the list of supplied arguments. In the example shown, the formula in F6 uses COUNTA like this: = COUNTA (C5:C16) // returns 9. 2. To get a function to count cells rather than hold data, the following syntax is used with SUMPRODUCT: Array1: This argument denotes the first array or range that will be multiplied and then added. Cells A2 to A8 have text values which can only be counted using the COUNTA Google Sheets function. To count numbers or dates that fall within a range (such as greater than 9000 and at the same time less than 22500), you can use the COUNTIFS function. EXCEL COUNTIF. The Excel COUNTIFS function returns the count of cells in a range that meet one or more conditions. =COUNTA(B2:B) counts the following: 65, 55, 70, 55, 81, 88, 61, "Failed", 92. How to use count function in excel2. See Also. Criteria 2. To count with one condition, use the COUNTIF function; To count with multiple conditions, use the COUNTIFS function. This means you can use COUNTA as a simple way to count cells that are not blank. Excel's COUNTIF function is quite interesting, as it combines the count function with a conditional function, IF. There are two different ways to use COUNT in Excel. This example counts cells in B2 through D6, and in B9 through D13. What worked best is to add a field to the source Excel Table called 'Records' with a numeric value '1' for every record; Then the Pivot Field Calculation is SUM (Field_1) /Records. In this case I want to find 'Sheo' text. It means 8 employees have received funds. Alternatively, type the number “9” (without the double quotation marks) manually. This function includes empty text ("") in the count. not blank). In the Select Specific Cells dialog box, select the cell range in the Select cells in this range section, choose Cell option in the Selection type section, specify. Second condition is Product : Carrot. In this example I have chosen 3 (COUNTA) which simply counts entries in non blank cells in the range. Use the COUNTA function to count only cells in a range that contain values. -- In DAX, there are no differences between COUNTA and COUNT. In this video, you can learn the Difference between the Count v/s Counta formula in Excel. COUNT function: The use of count function in MS Excel is to count numbers present in the text data. Select the range of values in which you want to count the unique values. The COUNT function in Excel allows you to count the number of cells that contain a number within a specified. There are about 30. Click Field Settings. 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. Excel will then display a list of all the non-blank cells in the selected range with their cell addresses. e. Forum Rules (updated August 2023): please read them here. 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 ”. Từng hàm trong số này trả về một số. Example 2. Use AutoSum by selecting a range of cells that contains at least one numeric value. เนื่องจากวันที่ หรือเวลา แท้ที่. COUNT(valueA,[valueB],…) COUNTA(A1:A3), the parenthesis, includes the range. Difference between COUNT and COUNTA Functions in Excel. In cell D1, you can enter the following formula: =COUNTA(A1:B10)+COUNTBLANK(A1:B10) As I said, this formula works in two parts: COUNTA function counts the cells where you have values. Type the following formula into the cell replacing the cell range with your own and hit Enter. 5. . Syntax. Blank and text values are ignored. COUNTA() vs. Step 4: Consequently, it will expand the “Find” dialog box. In this article, you will learn how to use the COUNTA in Excel. Interior. Press Enter. Sum. COUNTA: Counts the number of values in a column. 1. Here's the formula I'll use: =COUNTIF (C2:C17,">100") This is a simple, two part formula: simply point Excel to the list of data to count, and the rule to count. COUNTIFS() [03:25] UNLOCK NOW. The COUNT function counts cells containing number data and returns a result of five. Để bật tùy chọn: Mở. Using the DCOUNTA Function for Single Criteria. Heres a quick summary of what they do, followed by an example of each. COUNTA counts all types of data in the range and returns a result of nine. COUNTA stands for count all. . D_COUNT counts the number of unique items there are being aggregated. It can manage 255 parameters in total. Criteria can include. Array2: This argument denotes the second array or range that will be multiplied and then added. 1: count text values. Excel TREND() input arrays. Click on the “Find All” button. Use VLOOKUP with COUNTIF Function: 3 Ways. Excel returns the count of the numeric values in the range in a cell adjacent to the range you selected. ; After that, click. Cell E5 counts the date values in the range B2 to B8. If you enter any number data later in these cells, the counting cell will. To count empty cells, use the COUNTBLANK function. Are you looking for a way to quickly count the number of items in a cell range? Then this video might be for you. The data given are shown below: To count the cells with numeric data, we use the formula COUNT (B4:B16). The COUNTA function counts cells containing any type of information, including error values and empty text (""). The COUNT function counts the number of cells in a range that contain numbers. 🔏Formula Unlocking. Nhằm giúp bạn đọc hiểu rõ hơn về công thức cũng như cách sử dụng hàm counta trong excel, mời bạn đọc cùng xem qua một số ví họa dưới đây: 1. So, this section returns 15. Note that the COUNTA function counts the number of cells in a range that are not empty. Sintaxe: COUNT(valorA,[valorB],…) COUNTA(A1:A3), o parêntese, inclui o intervalo. You can reward them by clicking on * Add Reputation below their user name on the left, if you wish. To count cells with specific text in Excel, we can use CountIf () function. The formula in F6 is: = COUNTA (C5:C11) / COUNTA (B5:B11) At the core,. To count cells that are completely empty, use the Excel COUNTBLANK function, which has the following syntax, with one argument -- range: =COUNTBLANK (range) Follow these steps, to count the blank cells in the worksheet range A1:A5: Enter the sample data, shown below, on your worksheet, in cells. “=COUNTIF (B2:B21,”<>”&””)”. COUNTA function (DAX), Unlike COUNT, COUNTA supports Boolean data type. Cách sử dụng hàm đếm COUNT rất đơn giản, chỉ cần bạn chọn đúng vùng dữ liệu dưới. In the example shown, the formula in F6 is: = SUMPRODUCT (1 / COUNTIF (B5:B14,B5:B14)) In Dynamic Excel, you can use a simpler and faster formula based on UNIQUE. This means you can use COUNTA as a simple way to count cells that are not blank. DCOUNTA (database, field, criteria) The DCOUNTA function syntax has the following arguments: Database Required. This is the range from which you want to count the non-blank cells. =COUNTA () : 셀 참조 영역 범위 내 공백을 제외한 데이터의 개수만. Example 1: The following illustration returns the number of integer values in a given range. The generic syntax is COUNTIF(range, criteria), where "range" contains the cells to count, and "criteria" is a condition that must be true for a cell to be counted. Funkcia COUNTA nepočíta prázdne bunky. 3. Step 2: Press the “Enter” key. The CountA function counts the number of records that aren't blank in a single-column table. COUNT and D_COUNT, distinct counts, are ways of aggregating data. Dates and times are considered numbers in Google Sheets, which is why the data in cells B4 and B5 is counted by both functions. e. There are two very similar functions in Excel: COUNT() and COUNTA(). Perbedaan antara COUNT dan COUNTA adalah utilitas COUNT menghitung semua sel yang berisi angka atau nilai data dalam jangka waktu yang sempit, sedangkan tindakan COUNTA menghitung semua setengah sel di dalam rentang yang ditentukan, sebagaimana disediakan sebagai sel memiliki apa-apa. Steps:Select the cell range B2:B10 and enter “Shop_B” on the Name Box. Notes. This fx tab is available just below the Menu bar. and here is my result in B21. The next function we will use to count if not blank cells are present in a range is the COUNTA function. Here, I am gonna show you a simple way to apply the COUNTA function. When criteria includes more than one row, each row is joined with OR logic, and the expressions in a given criteria row are joined with AND logic. We will use it to count all nonblank cells. Aug 16, 2010. Select the range whose data needs to be checked for non-blank values. This is an array formula, so be sure to press Ctrl + Shift + Enter to complete it. This means that COUNTA is used to count cells that contain data of any type, including text, numbers, and errors. STEP 3: In the Create PivotTable dialog box, Excel will automatically select the table for you and the default location will be New Worksheet. 442 Trong Excel, các hàm COUNT, COUNTA, COUNTIF, COUNTIFS, COUNTBLANK được dùng để đếm dữ liệu, đối tượng trong chuỗi ở một bảng tính. To get a function to count cells rather than hold data, the following syntax is used with SUMPRODUCT: Array1: This argument denotes the first array or range that will be multiplied and then added. Sample. =COUNTA (A2:A8) This formula counts the values from cells A2 to A8. Utilizing COUNTA to Count Non-Blank Cells without Zero (0) and with a Formula Returning Null Value in Excel. 6: count cells that contain formulas. Key Takeaways: COUNT focuses on counting only numerical values, while COUNTA considers all non-empty cells. Unlike COUNT, COUNTA supports Boolean data type. This is the same cell that will display the count of blank cells. Next, enter the closing parentheses to close the function and enter. Now, we must click on the “Format” option. This is the reason for the COUNT function not working in Excel. COUNTA treats a zero-length string as a non-empty cell because it actually contains a formula. Select the cell where you want to display the result. Select the Count Distinct Values option from the menu. Range can contain numbers, arrays, a named range, or references that contain numbers. COUNT: Counts the number of rows in the table where the specified column has a non-blank value. To count rows based on multiple criteria (for example, green and greater than 9), use the following COUNTIFS function. The COUNTA function counts cells containing any type of information, including error values and empty text ( "" ). เนื่องจากวันที่ หรือเวลา แท้ที่. The COUNTA function returns the count of values in the list of supplied arguments. To count the cells that have values in. This tells us that there are 5 players with a value of “Guard” in the Position column where the corresponding value in the. Replace 'value1', 'value2', etc. 1. Excel returns the count of the numeric values in the range in a cell adjacent to the range you selected. ColorIndex = FillColor Then Count = Count + 1 End If Next c COLORCOUNT = Count End Function. 3. 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. 제가 첨부한 예제 샘플 보시면 바로 이해가 되지. Criteria 1. The CountA function counts the number of records that aren't blank in a single-column table. Excel COUNTIFS Function to Count Filter Data with Criteria by Adding a Helper Column. . Supposing, you have a list of item IDs in A2:A10 and you want to count the number of cells with a particular id, say "AA-01". I need the answer to be 15, one store doesn't have any grapes. So a formula that appears to have no output will instead output. The CountIf function counts the number of records in a table that are true for a logical formula. For Example:-COUNTIF Function: It is used to count the number of cells based on a specified condition. I am trying to ADD cells Y7 and Y26 and then divide by the number of cells that have a number in the cell. . This example counts cells in B2 through D6, and in B9 through D13. COUNTIF function: Counts cells which satisfy a given condition. COUNTBLANK counts how many blank cells in a range. In this example, we will compare the usage of COUNT and COUNTA functions on a sample dataset. Syntax : =COUNTA(value1,value2) Value1, Value2 are the range in which you want to count. Note: COUNTA() and COUNT() function does not work on the blank cells. are not. Types: Currently, three types of COUNT functions exist in Excel: COUNTA, COUNTBLANK and COUNTIF. Learn more about TeamsThe following is an example of the results of using the COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions: The ampersand (&) symbol to concatenate the reference. Description. Đối số đầu tiên đại diện cho giá trị. The COUNTA function can count cells containing several types of data values. Let’s assume we imported data and wish to see the number of cells with numbers in them. Press the Enter Key. COUNT Vs COUNTA. Two out of three responses are yes, which is equal to 67%. In other words, if you have a formula that returns a null string (=""), COUNTA will still count that cell, as it doesn't consider that to be truly blank. Navigate to the right bottom of your spreadsheet to see the count of cells. The first row of the list contains labels for each column. A window called “Function Arguments”. Ví dụ minh họa 1. The steps are listed as follows: Step 1: In cell F2, enter the following formula. Cú pháp. The following COUNT call: COUNT ( table [column] ) Copy Conventions # 1. 3. The Excel DCOUNT function counts matching records in a database using a specified field and criteria. It counts the number of cells in a range that contain. Let us follow the steps below to apply the VBA COUNTA function to get the total cells count containing the data in the range A2 to A12 in cell D2. Let us apply the COUNTA function to the range of cells A1:A5 provided in the below table to find the count of the number of cells that are not empty. The syntax of COUNTA Excel function is; =COUNTA (value1, [value2],. Over 200 free exercises and tutorials, Sheetzoom teaches the hardest vlookup, if, pivot tables and charts in Excel. 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. สูตร COUNT จะนับเฉพาะตัวเลข รวมไปถึงวันที่ เวลา ด้วยนะ. The Excel SUBTOTAL function with function_num 101-111 neglects values in hidden rows, but not in hidden columns. The COUNT function counts rows that contain the following kinds of values: Numbers. Here, Excel will return nine as a result. Select the cell you want to place the result. COUNT can handle up to 255 arguments. . Write the syntax or the formula of COUNTA and then determine the range of cells to be counted. range (required). COUNTIF/COUNTA with Dynamic Range in Excel. Column E is part A of the test, and Column F is part B of the test. The COUNTA function internally executes COUNTAX, without any performance difference. You use the COUNT function in Excel to count the number of cells that contain numerical values. This video tutorial provides a basic introduction into excel functions such as autosum, average, max, min, count, and autofill. For example, if you use a formula like SUBTOTAL (109, A1:E1) to sum numbers in a. Alternately, you can use. Hence, we need to store it in a cell, i. Method #1 – Writing the formula of CountA () function in the resulted cell. Add the IF function to find the duplicates. =AGGREGATE (3,3,B5:B13) As a consequence, you will get the count of visible rows only. Does not support Logical values (TRUE/FALSE values). Just add a calculated field with a formula to evaluate whether the cell has a valid value in it. Once you. Read More: How to Count If Cell Contains Number in Excel. =COUNTA (value1, [value2,. Messages. COUNT counts the number of items being aggregated. Let us apply both the functions COUNT FUNCTION and COUNTA FUNCTION on this data, and check the results. In Excel, to count a specific character, you need to use a combination of SUBSTITUTE and LEN functions. Whether you're a spreadsheet n. Note. Excel inserts curly brackets at the beginning and end of the formula for you. For example,. Type in the formula: = COUNTIF ( E2:E5, "Yes" )/COUNTA ( E2:E5 ); The answer 67% should appear in cell E6. To count empty cells, use the COUNTBLANK. Count is used to count the number of cells in a range that contain numerical data, whereas COUNTA is used to count the number of cells in a range that are not empty. Excel will enter structured references automatically when you reference parts of a table with point and click. Press OK. COUNTA takes multiple arguments in the form value1, value2, value3, etc. -- COUNT is the short version of COUNTX, when used with one column only. Secondly, the function adds a range of cells that you will specify with a special condition or criteria. In other words, if you have a formula that returns a null string (=""), COUNTA will still count that cell, as it doesn't consider that to be truly blank. Now to count the total cells but not blank, use COUNTIF. Trong Excel, các hàm COUNT, COUNTA, COUNTIF, COUNTIFS, COUNTBLANK được dùng để đếm dữ liệu, đối tượng trong chuỗi ở một bảng tính. (FYI - formulas also make a cell non-empty, since they must have an output. . The only thing not counted by the COUNTA function are cells that have absolutely no information. Generally, this result is displayed in a cell to the right for a horizontal range or in a cell below for a vertical range. In cell E2, type an equal sign ( = ), and click cell C2. Used By: Used for registers and record maintenance purposes dealing with time and dates. Whether you're a spreadsheet n. COUNT FUNCTION can be used when we want to count. 8. 하나씩 설명드려보겠습니다. COUNTA will count "blank" cells if they are blank as the result of a formula. COUNT function counts cells that contain only numbers, but COUNTA function counts cells that are not blank, including numbers. This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules. ”. Blank and text values are ignored. Imagine if you have rows and rows of data and you need a quick count. . Go to the Data tab. The formula returns the value 4, which is the number of duplicate items between the two lists. For example, cells A1 and A3 contain values but, cell A2 is empty. Difference between COUNT and COUNTA with Example. Counts the number of cells in a range that contain any value (text, numbers, logical values, or errors). 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. : SUM (Field_1)/RowCount. You can see that the cells are in Text format in the Number Format drop-down box in the Number group of commands. You can reward them by clicking on * Add Reputation below their user name on the left, if you wish. Select the column you want to count. Follow the steps below: Steps: In cell D4, write the following formula. It is typed =COUNT. COUNTA does not count empty cells. The COUNTA function counts the number of cells in a range that are not empty. So unlike the COUNT function, which considers only numbers, COUNTA considers numbers, dates, text values, logical values, and errors. Since only three of the four cells in the range contain data, the formula calculates the percentage of yes responses out of three. After that, Excel. How to Count the Number of Multiple Values. Excel COUNTIFS Function to Count Filter Data with Criteria by Adding a Helper Column. When the function does not find any rows to count, the function returns a blank. We will click on any count in Column G of the Pivot Table. In order to count the number of cells that are blank in the cell range E5: E15, we input the following formula into Cell E17. Select “COUNTA” from the drop-down menu. 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. COUNT counts the number of items being aggregated. Think of COUNTA as “count all or anything” because it counts every non-empty cell within a specified range. There are no types of COUNTA function as it itself is a type of COUNT function. 1. To get the total rows or columns in an Excel table: =ROWS(table) =COLUMNS(table) To count or sum items in a column: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. TOP 5 Excel Count Formulas | How to use COUNT , COUNTA , COUNTBLANK , COUNTIF and COUNTIFS1. If you want to count logical values, text, or error values, use the COUNTA function. Make sure the My table has headers box is checked, and click OK. 20. 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. Now, we must click on the “Format” option. Whenever the function finds no rows to aggregate, the function returns a blank. At the very beginning, select cells in the D16:D17 range. 2. 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. Bài viết này mô tả cú pháp công thức và cách dùng hàm COUNTA trong Microsoft Excel. 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. If I were to use COUNTA to count the entries in a normal table column, it would count the. Strings. Enter your data or use existing data. Since only three of the four cells in the range contain data, the formula calculates the percentage of yes responses out of three. COUNTIFS function can handle multiple criteria as arguments and counts the cells only when all the criteria are TRUE. COUNT ignores the logical values TRUE and FALSE. A value argument could be a hardcoded value, cell reference or a range. Description. Dates. MEASURE Customer[# Customers] = COUNTROWS (. The COUNTIF and COUNTA functions can be combined to get the percentage of a specific value in a range of data in Excel. COUNTA is a significant formula in Excel as it helps users to quickly and easily count the number of cells with data, allowing for efficient data analysis and management. Learn Excel using Excel, online and interactively with intelligent feedback. Step 1: In Excel, enter the data as shown in the following image. Let's call that the result cell. Your IF statement returns a null string if G2=G1, so this is definitely your problem. When we apply COUNT() function to count the cells, excel will return 0. Click "Sort & Filter" and choose "Filter. can be any values or authority to cell ranges. Example 1 – Excel Countif not blank. Note: To use the COUNTA function, select the range of cells you want to count. In this example I have chosen 3 (COUNTA) which simply counts entries in non blank cells in the range. Hàm CountRows đếm số lượng bản ghi trong một bảng. can you help me if this is possible to do in excel, I want to count the number of cells containing the specific value that is within a specific row or column that is in between a specific. The COUNTA function is a premade function in Excel, which counts all cells in a range that has values, both numbers and letters. We can use the following formula to count the number of cells in column A that have a value of “East” or “South”: =SUM(COUNTIF(A:A,{"East", "South"})) The following screenshot shows how to use this formula in practice: We can see that a total of 5 cells have a value of “East” or “South” in column A. Dacă nu doriți să contorizați valori logice. Use COUNT when you specifically want to count numerical data points. DCOUNTA Function in Excel: 5 Different Cases. In order to sum cells based on only one criteria then use the following SUMFIF function with two arguments. 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. COUNT vs. =COUNTA (value1, [value2], [value3]…) For value1 we will use a cell range – for example, to count the cells in range A1:D4, we will type: =COUNTA (A1:A4) We can use this function to check multiple ranges, by typing additional range in [value2], [value3] etc…. Note: “CountA ()” function will not count the blank or empty cell. Example: Using COUNT and COUNTA in Excel. To count with one condition, use the COUNTIF function; To count with multiple conditions, use the COUNTIFS function. It is typed =COUNTA. The formula. But scroll down to the bottom. The COUNT function considers all cells, not just those with numbers or dates. value2, value3. 3: count dates. Now type the formula stated below in that cell. The COUNTA function does not count empty cells. The COUNT function in Excel is a statistical. 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. Syntax. You can then use the Count Numbers option in the Sum list or enter the formula manually. Excel COUNTIF function is utilized for counting cells inside a. Data aggregation is the process of combining a list of items into one data point. 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. ; After that, click. Description. CountBlank function : CountBlank function will give you total no. Funcția COUNTA contorizează celule care conțin orice tip de informații, inclusiv valori de eroare și text gol ( „” ). STEP 3: In the Create PivotTable dialog box, Excel will automatically select the table for you and the default location will be New Worksheet. I have used sumproduct for the teams and profession but i don't know how to add the counta section at the add. We apply both the function on the given data. COUNTIF is a simpler function if you only need a single check. Click OK after entering both range & criteria arguments. COUNT VS COUNTA RESULTS. D_COUNT counts the number of unique items there. Hence, excel will skip such empty cells and counts only the cells that contain any type of data. Select a range. To count those unique values instead of listing them, you add the COUNTA function to the beginning of the formula: =COUNTA (UNIQUE (A2:A5)) Now you have the count for those unique values which is 3. In this example, we will compare the usage of COUNT and COUNTA functions on a sample dataset. A number, expression, cell reference, or text string that determines which cells will be. COUNTIF can be used to count cells that contain dates, numbers, and text. Q&A for work. COUNT function: Counts only the cells which have numeric value. Your IF statement returns a null string if G2=G1, so this is definitely your problem. COUNTA Function in Excel: 3 Simple Examples. A database is a list of related data in which rows of related information are records, and columns of data are fields.