COUNTIF function - Microsoft Support
网页Learn how to use COUNTIF function to count the number of cells that meet a criterion, such as a value, a text, or a wildcard. See syntax, examples, and tips for using COUNTIF with multiple criteria or named ranges.
Ways to count values in a worksheet - Microsoft Support
网页Learn how to use various Excel functions and features to count cells, rows, or columns of data based on different conditions and criteria. Download examples, watch videos, and see syntax and tips for each method.
Count how often a value occurs - Microsoft Support
网页Learn how to use Excel formulas and functions to count the number of times a value appears in a range of cells. See examples of COUNTIF, COUNTIFS, IF, SUM, and PivotTable methods.
COUNT function - Microsoft Support
网页Learn how to use the COUNT function in Excel to count the number of cells that contain numbers, and to count numbers within a list of arguments. See syntax, examples, and remarks for the COUNT function.
Count numbers or dates based on a condition - Microsoft Support
网页Learn how to use the COUNTIF, COUNTIFS, and SUMPRODUCT functions to count cells that meet a single or multiple criteria in Excel. See examples of how to count numbers, dates, and invoices with different conditions.
Count numbers greater than or less than a number
网页Learn how to use the COUNTIF function to count the number of cells that are less than a specific value in Excel. See an example of how to apply this function to a range of invoice values and get the result.
Count the number of rows or columns in Excel - Microsoft Support
网页Learn how to use the status bar at the bottom of Excel window to count rows or columns that contain data. Select the column header or the row selector to see the count, or customize the status bar options.
Count unique values among duplicates - Microsoft Support
网页Learn how to use a filter dialog box, functions, or array formulas to count the number of unique values in a range that contains duplicates. See examples, formulas, and function details for Excel for Microsoft 365, Excel for Mac, and Excel for the web.
COUNTIFS function - Microsoft Support
网页Learn how to use the COUNTIFS function in Excel to count the number of cells that meet multiple criteria across multiple ranges. See syntax, arguments, examples, and tips for using wildcard characters and cell references.
COUNTA function - Microsoft Support
网页Learn how to use the COUNTA function in Excel to count the number of nonempty cells in a range. See syntax, arguments, remarks, and examples of the COUNTA function.
Count characters in cells - Microsoft Support
网页Learn how to use the LEN function to count the characters in cells, including letters, numbers, spaces, and punctuation. See examples, formulas, and tips for applying the function to multiple cells or a range of cells.