Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel Web App Excel 2010 More...Less Show
The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met.
This video is part of a training course called Advanced IF functions. SyntaxCOUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) The COUNTIFS function syntax has the following arguments:
Important: Each additional range must have the same number of rows and columns as the criteria_range1 argument. The ranges do not have to be adjacent to each other. Remarks
Example 1Copy the example data in the following tables, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
Example 2
Need more help?You can always ask an expert in the Excel Tech Community or get support in the Answers community. See AlsoTo count cells that aren't blank, use the COUNTA function To count cells using a single criteria, use the COUNTIF function The SUMIF function adds only the values that meet a single criteria The SUMIFS function adds only the values that meet multiple criteria IFS function (Microsoft 365, Excel 2016 and later) Overview of formulas in Excel How to avoid broken formulas Detect errors in formulas Statistical functions Excel functions (alphabetical) Excel functions (by Category) Need more help?Which of the following function automatically counts cells that meet multiple conditions?Count cells in a range based on multiple conditions by using the COUNTIFS function.
Which of the following functions summarize cells that meet multiple criteria?SUMIF function. If you want, you can apply the criteria to one range and sum the corresponding values in a different range. ... . To sum cells based on multiple criteria, see SUMIFS function.. Which function would you use to determine the number of occurrences?Count how often a single value occurs by using the COUNTIF function. Use the COUNTIF function to count how many times a particular value appears in a range of cells.
Which of the following functions returns one value for condition is true and different value when the condition is not true?Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false.
|