Each condition is provided as a "pair" of arguments: range + criteria. COUNT vs. The following example returns all rows in the Reseller table that have any kind of value in the column that stores phone. COUNT VS COUNTA RESULTS. =IF (C4="Fruit",1,0) order: a number specifying how to rank the numbers. If a cell has any character in it, that will count as data. The values can be anything as long as something is in the chosen cell or range. However,. To be exact, COUNT (column) counts rows in which values of column is not NULL, whereas COUNT (*) counts all rows of the table. MODE: Returns the most commonly occurring value in a dataset. Counts any field in the Units Sold column that contains a value. It adds a column but will be dynamic. In cell D1, you can enter the. Kegunaan. ฟังก์ชัน Count นับจำนวนเรกคอร์ดที่มีตัวเลขในตารางแบบคอลัมน์เดียว. Read here about how to avoid using Select. Cell E5 counts the date values in the range B2 to B8. However, if pk is not constrained to be not null, then it produces a different answer:In this short tutorial, I show how to use the COUNT and COUNTA functions in Excel. Blank values are skipped. Syntax. This video includes topic of CountA Formula in Excel which covers the following. Examples: 1. : 'Year. METHOD 4: Ungroup values in the Pivot Table. For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value. CountA (Range ("B1:B6")) End Sub. =COUNTA (A2:A8) This formula counts the values from cells A2 to A8. 통계 함수는 위 말씀드린 것과 같이 4가지로 이루어져 있습니다. Syntax. To count, choose a cell and enter the COUNT syntax: = COUNT (Range). COUNT and D_COUNT, distinct counts, are ways of aggregating data. . Re: Need help on doing COUNT or COUNTA on Pivot table. คำอธิบาย. For example, cells A1 and A3 contain values but, cell A2 is empty. . D give an example of when you would use the count and. 1. 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. Using the DISTINCT clause with the aggregate function COUNT works by adding the keyword within the parentheses and before the column name to be counted in the SELECT statement. =COUNTA(A1:A10)-COUNT(A1:A10) This formula will return the number of cells that only contains letters. 2. If you want a bit more detailed explanation on the mentioned formulas, we have a blog post about Excel COUNT, COUNTA and. Use VLOOKUP with COUNTIF Function: 3 Ways. Select the cell where you want to see the result, the actual count. Often you may want to use the COUNTA function with an IF function to count the number of cells that are not empty only if a cell in a corresponding column meets a certain requirement. However, this will only return the sum of separate. First, in cell B2, enter the function SUBTOTAL. 103 - is similar to COUNTA, but ignores empty rows and also respects filters. To count the number of cells in the range A1 through D7 that contains numbers, you would type the following and hit Enter: =COUNT (A1:D7) You then receive the result in the cell containing the formula. count vs. Count Distinct Values in Excel. As Date and Time values are stored as serial numbers in Excel so these values are counted in both of these functions. of a range of values. any help. For some reason <>"" doesn't work so I used: =IF (OR (NOT (Value<=0),NOT (Value>=0)),1,0)Basic statistical functions including COUNT, COUNTA, AVERAGE, MAX, MIN, MEDIAN, and MODE. 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". The Excel COUNTA Formula; Examples of COUNTA; COUNTA vs COUNT; The Excel COUNTA Formula. Rumus COUNTA pada Excel berguna untuk menghitung berapa banyak cell yang berisi data dan mengabaikan cell kosong. When the function finds no rows to count, it returns a BLANK, otherwise it returns the count of distinct values. COUNTA In a nutshell, the COUNT function counts all the cells with numbers or date values within a specified range whereas the COUNTA function counts all the non-empty cells within a specified range, as long as the cell has something. Formula 1. To count only numeric values use COUNT. You can use the COUNT function to count column values, or you can use the COUNTROWS function to count table rows. count vs counta Da bi se prikazala razlika između dvije funkcije, primjer na gornjoj slici uspoređuje rezultate za COUNTA (ćeliju C2) i bolju poznatu funkciju COUNT (ćelija C3). Usually the COUNTAX function does not count empty cells but in this case. The Count function counts the number of records that contain a number in a single-column table. It adds a column but will be dynamic. Biên tập bởi Nguyễn Xuân Hòa Đăng 1 năm trước 165. Select COUNTA from the list of multiple available functions which allows you to count the non-empty cells or values. COUNTBLANK is the most convenient but not the only way to count empty cells in Excel. COUNT (pk) also counts the number of rows. Can. 이상으로 엑셀함수 정리 해 봤는데요. COUNTA: Returns the number of values in a dataset. COUNT FUNCTION can be. Sự khác biệt giữa các hàm COUNT và COUNTA trong Excel khi tất cả các giá trị đều là số. . 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. . COUNTA can operate on a Boolean data type, whereas COUNT cannot do that. Type this string in the second argument, and you will get this simple. . The result of a tally that reveals the number of items in a set; a quantity counted. COUNTA Function Syntax =COUNTA(value1, [value2],. 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. 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. In the count form, the noun refers to a specific example or type. The COUNT formula =COUNTA(A2:A12,D2:D12) results in a total count of 22. It counts the number of cells in a range that contain. SUMIFS in Excel COUNTIF vs. Here’s how to count cells containing text in Google Sheets:: Select the cell where you want to display the count. Both are based on preset norms that specify what counts and what doesn't. Any value other than these would not be counted in by the COUNT function. 이상으로 엑셀함수 정리 해 봤는데요. ) Ditto COUNT function formula examples. The database argument is a range of cells that includes field headers, field is the name or index of the field to count, and criteria is a range of cells with headers matching those in. COUNT and COUNTA are identical in DAX for all the data types except Boolean. COUNTIF vs VLOOKUP for. =AGGREGATE (3,3,B5:B13) As a consequence, you will get the count of visible rows only. You can input multiple values for COUNTA to look. 20. Criteria can include. Examples of COUNTA; COUNTA vs COUNT; Let’s get started with the formula. Obviously I don't have FastExcel figures, but in the poor-man's test I ran, the Countif seemed more efficient during the calc. Click OK. In addition, COUNTX is generally used for the appearance of measurements or numeric values. SQL COUNT DISTINCT. 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. Mô tả. COUNT: Counts the number of rows in the table where the specified column has a non-blank value. It's job is to search a range for a value and tell you how many cells match that value. COUNT. The formula for it in Google Sheets is: =COUNTA (value1, [value2, value3, etc…]) . In under 10 minutes, learn how to write exc. are cell references or ranges within which you want to count cells with numbers. Row 13 meets this criteria, but has been hidden. Ngoài ra. ; The COUNTA function counts the number of cells in a range that are not empty. 5. . By combining both functions you can count all the non-blank cells and all the blank cells from a range. Dummy data or not, my expectation is that you are getting a similar result due to the count seeing " " as data. The COUNT function may be used to count whole numbers, whereas the COUNTA function can tally the number of non-blank cells. Counts the number of cells in a range that contain any value (text, numbers, logical values, or errors). Think of it as “Count Anything”. If there's an index on a, then SELECT MAX (id) FROM tbl WHERE a=constant uses a so-called loose index scan. The COUNT function only counts numeric data. 4. The COUNT function counts cells containing number data and returns a result of five. COUNT vs COUNTA. Otherwise, the function returns Red. I know I said “two ways to count”, so think if this as a bonus. WorksheetFunction. CountA() resembles the base Count() function found in DAX in most respects, but, like most “A” functions, differs from the base function in the fact that it is designed to handle non-date and. Strings. Where value1, value2, etc. To count the number of multiple values (e. Supply wt to perform weighted counts, switching the summary from n = n() to n =. COUNTA treats a zero-length string as a non-empty cell because it actually contains a formula. create table t(a int) insert into t values (1),(2),(3),(3) select count (distinct a) from t select distinct count (a) from t group by aThe next function we will use to count if not blank cells are present in a range is the COUNTA function. 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. Only the numbers of selected cells will be counted. + Hàm COUNT dùng để đếm số ô có chứa dữ liệu là số trong 1 vùng Dữ liệu ( phạm vi) + Hàm COUNTIF là hàm dùng để đếm số ô chứa Dữ liệu thỏa mãn điều kiện nào đó. For example, the "CountIf" function lets you count only cells with numbers that meet certain criteria, such as dates or times. NOTE: Please mark the message or messages (yes, you can mark more than one) that. To count rows where two (or more) criteria match, you can use a formula based on the COUNTIFS function. The following COUNT call: COUNT ( table [column] ) Copy Conventions # 1. The COUNTA function counts cells containing any type of information, including error values and empty text ( "" ). Excel COUNTIFS Function to Count Filter Data with Criteria by Adding a Helper Column. Column E is part A of the test, and Column F is part B of the test. Here's a video that could help you:. Para contar solo los valores numéricos, usa. COUNT, COUNTA, COUNTIF 함수의 경우 데이터가 많을 때 다양한 갯수를 뽑기 위해서는 매우 유용합니다. Assuming the pk is a primary key and that no nulls are allowed in the values, then. You can input multiple values for COUNTA to look. Any. Menghitung. Use DCOUNT to count only numeric values. While both functions serve a similar purpose, there are distinct differences between them. Calculate Percentages Using VLOOKUP and COUNTIF functions. Strings. Blank values are skipped. In the example shown, the formula in F5 is: =COUNTA(UNIQUE(B5:B16)) which returns 7, since there are seven unique colors in B5:B16. Where COUNT calculates the number of cells with a numerical value, COUNTA simply counts. COUNTIF function: Counts cells which satisfy a given condition. COUNTA 📊Welcome to DAQ - Data Analyst Quest! 🚀 In this quick tutorial, we delve into the world of Exce. Sub TestCountA() Range("B8) = Application. In short: . Where/when to use the technique. Study with Quizlet and memorize flashcards containing terms like COUNT vs COUNTA, the round function num_digits, countif does what and more. ]) You can select cells one by one, but also ranges, or even multiple ranges. 21. Excel inserts the SUBTOTAL function automatically, and you can use a drop-down. COUNTA Function. 17K subscribers Subscribe 20 425 views 10 months ago Not getting the result you're. So, Let's get started! The Episode covers the following information: 1. This step by step tutorial will assist all levels of Excel users in comparing these functions. Use the SUBTOTAL function to exclude filtered or hidden rows when calculating a total on the worksheet. Suppose you wanted to return a range containing all the cells in column A with a value. Sum. This example counts cells in B2 through D6, and in B9 through D13. 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. It ignores any. To show the difference, I will consider two aspects of these functions. Table (single-column) Example: Count ( [1,2,3]) will return 3. The table could be a model table or an expression that returns a table. To count numerical numbers, you can use cell ranges, cell references, values, or a combination of all four. And yes, you could probably count the blanks in this example yourself, but imagine doing that in a big. Ví dụ, nếu phạm vi chứa một công thức trả về chuỗi trống, thì hàm COUNTA sẽ đếm giá trị đó. When the function does not find any rows to count, the function returns a blank. During this session, we will cover COUNTA, COUNTX, COUNTAX, COUNTBLANK, DISTICTCOUNT, DISTICTCOUNTNOBLANK and COUNTROWS DAX functions. Dates. COUNTA in Excel. Unlike the COUNT function, which counts only numbers, COUNTA counts. To use it: Type =COUNTA ( into a blank cell. Countrows, count, countA, and a new one called distinctcount which is really, really helpful. It is a more versatile function than COUNT, but it can be slower to calculate. =COUNTIF (G9:G15, "Pens")+COUNTIF (G9:G15, "Erasers") This counts the number of erasers and pens. ฟังก์ชัน CountA นับจำนวนเรกคอร์ดที่ไม่ใช่ ค่าว่าง ใน. Additional Resources. COUNTA is a built-in Excel function that looks through the values you feed to it and counts the number of values that aren't blank. 1. SELECT COUNT(DISTINCT a_number) Counta_number FROM #AGG_TEST; Note: COUNT DISTINCT must be paired with a. Learn Excel Online with Sheetzoom. In simpler terms, COUNT is used to count cells that contain numbers, while COUNTA is used to. Ada beberapa keadaan dimana Anda sangat membutuhkan Fungsi COUNTA untuk. =SUBTOTAL(103, A1:A200) will help you get count of non-empty rows, respecting filters. COUNTA can operate on a Boolean data type, whereas COUNT cannot do that. Whether you're a spreadsheet n. As a data modeler, sometimes you might need to write a DAX expression that counts table rows. Values in rows that have been "filtered out" are never included, regardless of function_num. 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. ฟังก์ชัน COUNTA จะนับเซลล์ที่มีข้อมูลชนิดใดๆ รวมถึงค่าความผิดพลาดและข้อความว่าง ( "") ตัวอย่างเช่น ถ้าช่วงมีสูตรที่. Not getting the result you're looking for? It's not your fault! There are some confusing nuances to these functions. COUNTA can support datatype boolean count. To count numbers and text, use the COUNTA function. The COUNTA function counts the number of cells that are not empty in a range. See Also. The difference between COUNT and COUNTA is that the COUNT utility tallies all the cells containing numbers or data value within a narrow time frame, whereas. See the NOTE section below for more information. Penulisan formula/rumus COUNTA: =COUNTA (Sel Awal : Sel Akhir) Atau bisa juga dituliskan. ) after object specified and you will see a list of functions available to use under it. COUNTA counts cells that contain text, numbers, logical values, and formulas. Over. COUNTA(value1, [value2],. How to Count the Number of Multiple Values. For example, if you want to count all the cells in column A, you would use A:A as the range. (legal) A charge of misconduct brought in a legal proceeding. COUNTA:Select the cell where you want to see the result, the actual count. For example, if the column contains an expression that evaluates to an empty string, the COUNTAX function treats that result as non-blank. COUNT and COUNTA are identical in DAX for all the data types except Boolean. Rumus Excel COUNTIF, COUNTIFS, COUNTA, dan COUNTBLANK adalah fungsi ( function) yang digunakan untuk menghitung banyaknya data (COUNT). COUNTA works in a similar way. 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. Count and CountA works in same manner however. The COUNTA function counts the number of cells in a range that are not empty. For example, SUM is an aggregation where the listed values are added together. The same result can be achieved by subtracting one Countif formula from another. A diferença entre COUNT e COUNTA é que o utilitário COUNT registra todas as células que contêm números ou valores de dados dentro de um período de tempo estreito, enquanto a ação CONT. When all inputs to the function are numbers, it produces the same result as the COUNT function. The choice between COUNT and COUNTA largely depends on the nature of the data you’re working with and what you want to achieve. COUNTIF is a very simple function. Count nonblank cells in a list with specific conditions by using the DCOUNTA functionIn B column, some data is numeric, some data is alphabetic and some cells are blank. I don’t mean blank cells, I mean cells with empty text like for example if you entered a space in a cell then COUNTA would count that cell. The syntax for this function is COUNTA(value1, [value2],. Notes. For counting, you need to select a cell and then enter the syntax, =COUNT (Range). Description. ; The COUNT function is useful for counting the number of. It includes cells with both numerical and non-numerical values. Basic statistical functions including COUNT, COUNTA, AVERAGE, MAX, MIN, MEDIAN and MODE. . In this video, we'll give the reasons why you should always use CountRows over Count in DAX measures in Power BIAVERAGE vs. Hàm này bao gồm văn bản trống ("") trong tổng số. 04-24-2020 02:46 AM. Count the Rows with the Non-Blank Cell. The COUNT function is used to count the occurrences of a specified numeric value inside a given range or array. Counts any field that contains a value and is the child row 1 in the "Item Number column. 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. Select COUNTA from the list of. . Combine COUNTA – COUNTBLANK to Count Cells from a Range. This example counts cells in B2 through D6, and in B9 through D13. valores registra todas as células semi-meias dentro de um intervalo definido, desde que a célula tenha qualquer coisa. The B column is formatted as dates and COUNTA calculates and returns the total which is 7. 📊 Data Analyst Quest (DAQ): Understanding COUNT vs. COUNTIF: Returns a conditional count across a range. COUNTA 📊Welcome to DAQ - Data Analyst Quest! 🚀 In this quick tutorial, we delve into the world of Exce. To count the cells which are populated with any sort of data, we would need to use the COUNTA function. After the FILTER function is applied to the table, the expression would be equivalent to. That may sound a bit illogical, but Excel does work this way :) How to count blank cells in Excel - formula examples. ” From that misconception follows a second: that COUNT(1) is faster because it will count only the first column, while COUNT(*) will use the whole table to get to the same result. This applies to MySQL. To get the distinct count in the Pivot Table, follow the below steps: Right-click on any cell in the ‘Count of Sales Rep’ column. The COUNTA function is a premade function in Google Sheets, which counts cells that has values, both letters and numbers. This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules. We would like to show you a description here but the site won’t allow us. The CountIf function counts the number of records in a table that are true for a logical formula. That means if any value repeats more than one time, it only counts once. COUNTA counts how many populated cells in a range (i. Give the chairs a quick count to check if we have enough. Learn how to use COUNT and COUNTA functions in Excel to count cells containing different types of values, such as numbers, text, logical values, error values, and formula returning empty text string. The CountA function counts the number of records that aren't blank in a single-column table. The COUNT function counts the number of cells in a range that contain numbers. not blank). Also, learn a. The SUBTOTAL function can easily generate sums and counts for visible rows. 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 : นับเฉพาะข้อมูลที่. Click on cell E6 to make it the active cell; Type in the formula: = COUNTIF ( E2:E5, "Yes" )/COUNTA ( E2:E5 ); Press the Enter key on the keyboard to complete the formula; The answer 67% should appear in cell E6. need help with that > i try to use how to use Application. 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. Since only three of the four cells in the range contain data, the formula calculates the percentage of yes responses out of three. In the Value Field Settings dialog box, select ‘Distinct Count’ as the type of calculation (you may have to scroll down the list to find it). COUNTA ignores the blank values in D3, D4, D8, and D11. Internally though, LINQ checks if your IEnumerable implements ICollection and if it does it uses the Count property. Cell E5 counts the date values in the range B2 to B8. Unlike DCOUNT, which counts only numeric values, DCOUNTA counts both numeric and text values. COUNT function in Power BI DAX has lots of. Entrada siguiente →. The C ounta function counts boolean functions. =COUNTA(C2:C) works with 80, 75, 69, 60, 50, 90. Distinct Count: The measure ‘Count Countries’ shows that a total of 11 countries are present in the Sales Territory table. Example 1 – Excel Countif not blank. The formula “=COUNTA (A1,A2,A3)” returns 2. Step 6: Specify the arguments manually. – (optional, up to 30) additional values to also be included in the count. In a nutshell, the COUNT function counts all the cells with numbers or date values within a specified range whereas the COUNTA function counts all the non-empty cells within a specified range, as long as the cell has something. COUNT vs COUNTA. As we’ve understood by now, COUNTA function in Excel counts non blank cells in Excel regardless if the cells contain text, numbers, dates, errors and empty text strings. It needs to be understood that " " or "" is not blank, nor is it null. ( en noun ) The act of or tallying a quantity. This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules. The left parts of the merged cells are excluded from this range, therefore are not considered by COUNT. If you want to count logical values, use the COUNTAX function. The COUNT function only counts cells containing specified values. =COUNTA(B5:B15) Press the keyboard shortcut CTRL+ENTER after that. Dans Excel, il existe deux fonctions fréquemment utilisées COUNT et COUNTA. 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. DAX trata datos en forma tabular con tipos bien definidos para cada columna, mientras que las fórmulas de Excel funcionan con valores de celda heterogéneos, sin tipos bien definidos. I want to stress this point as you could be. With A1 blank, for example, =ISBLANK (A1:E1) returns TRUE. Use COUNT when you specifically want to count numerical data. When passed an array, though not array-entered or co-erced to return an array, most formulae, including ISBLANK, will perform the operation on (and return the result for) the first value in. COUNTIF in DAX - DATA TABLE. 1. To sum cells based on one criteria use the following SUMIF function with three arguments, the last argument is to range the sum. COUNTBLANK is the most convenient but not the only way to count empty cells in Excel. Here we used 103 which ignore the hidden rows while applying the COUNTA ; For example,. I'm not sure about the others. In that scenario, it’s the three decimal places in every measurement. If the function finds no rows to count, it returns a blank. Syntax. COUNTA is fully automatic, so there is nothing to configure. COUNT comes from Excel and will count the number of cells in a column that contain a number. . COUNTIF counts how many cells in a range meet a certain condition. Example – 2: In the other scenario, I want to get the total number of “. (Ignores text). Sometimes, you may be asked to determine how many values exist in a list, including text. Viewer Count. Example – 2: In the other scenario, I want to get the total number of “. All good so far. . #excelfunctions #count #counta #countblank #countuniqueWelcome back Alien . However, when the inputs are text or boolean values, the. If you want to count text or logical functions, you need to use COUNTA. COUNT comes from Excel and will count the number of cells in a column that contain a number. ) You can insert the values directly or refer to a cell or a range that contains them. CountUser = CALCULATE (COUNTA (EMPLOYMENTS [Member_C]),FILTER (ALL (EMPLOYMENTS),EMPLOYMENTS [Member_C]=INDIVIDUAL [User_ID])) Regards, Charlie Liao. COUNTA in Excel. COUNTBLANK: Count Blank Cells . ฟังก์ชัน CountA นับจำนวนเรกคอร์ดที่ไม่ใช่ ค่าว่าง ใน. 바로 시작해보겠습니다. AVERAGEA in Excel SUMIF vs. 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. DAX trata datos en forma tabular con tipos bien definidos para cada columna, mientras que las fórmulas de Excel funcionan con valores de celda heterogéneos, sin tipos bien definidos. First, there is no semantic difference between select count (1) from table vs. 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. Trong bài viết này. Like the COUNTA function, the COUNTAX function counts cells containing any type of information, including other expressions. Range ("A2") = WorksheetFunction End Sub. In this video, you can learn the Difference between the Count v/s Counta formula in Excel. This article describes the formula syntax and usage of the COUNTA function in Microsoft Excel. If I were to use COUNTA to count the entries in a normal table column, it would count the. My self-trained instincts tell me that the formula should look something like: =COUNTA (COUNTIFS (A:A,"2013",B:B, I9)), (E:E) Where I'm looking for FY 2013, and the student's name is in cell I9 in this example. The formula for it in Google Sheets is: =COUNTA (value1, [value2, value3, etc…]) .