Use the COUNTIF function in Microsoft Excel
How to use the COUNTIF function in Excel to count the number of cells that meet values you set.
How to correct a #VALUE! error in the COUNTIF/COUNTIFS function
This topic lists the more common causes of the #VALUE! error in the COUNTIF and COUNTIFS functions. Problem: The formula refers to cells in a closed workbook COUNTIF/COUNTIFS functions …
Ways to count values in a worksheet - Microsoft Support
Use the status bar for simple counting in Excel, or use functions to count cells that contain data, are blank, or meet specific conditions or multiple criteria.
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.
SUMPRODUCT function - Microsoft Support
How to use the SUMPRODUCT function in Excel, one of Excel’s math and trig functions, using multiplication, addition, subtraction, and/or division to return the sum of the products of …
IF function - Microsoft Support
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The …
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.
SUMIFS function - Microsoft Support
How to use the SUMIFS function in Excel, one of Excel’s math and trig functions, to add arguments that meet multiple criteria.
MAXIFS function - Microsoft Support
The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria: numbers, dates, text, etc. This feature is available on Windows or Mac if you have Office …
Excel help & learning - support.microsoft.com
Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.