Use the COUNTIF function in Microsoft Excel
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.
COUNTIFS function - Microsoft Support
How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.
COUNT function - Microsoft Support
If you want to count logical values, text, or error values, use the COUNTA function. If you want to count only numbers that meet certain criteria, use the COUNTIF function or the COUNTIFS …
Count numbers or dates based on a condition in Excel
See examples of how to use worksheet functions to count numbers or dates that fall within a range in Excel.
Ways to count values in a worksheet - Microsoft Support
Watch the following video to see how to use the COUNT function and how to use the COUNTIF and COUNTA functions to count only the cells that meet conditions you specify.
COUNTA function - Microsoft Support
If you want to count only cells that meet certain criteria, use the COUNTIF function or the COUNTIFS function. Example Copy the example data in the following table, and paste it in cell …
Use COUNTA to count cells that aren't blank - Microsoft Support
View an example of how to use the COUNTA function to count cells that are not empty in a range of data.
Using IF with AND, OR, and NOT functions in Excel
How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.
DCOUNT function - Microsoft Support
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.
SUMPRODUCT function - Microsoft Support
The following example uses SUMPRODUCT to return the total net sales by sales agent, where we have both total sales and expenses by agent. In this case, we're using an Excel table, …