Excel Formulas to Create a Two-way summary Count with COUNTIFS!!

In this article, we will show the formulas to create a two-way summary count with COUNTIFS Function in Excel Office 365. Let’s get started!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formulas to create a two-way count with COUNTIFS

General Formula:

• To create a two-way summary count with COUNTIF Function in Excel, use the below formula.

=COUNTIFS(range1,criteria1,range2,criteria2)

Syntax Explanations:

• COUNTIFS – In Excel, this function will help to count the number of cells that meet multiple conditions or criteria.
• Comma symbol (,) – It is a separator which helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.
• Range – It represents the input range from your worksheet.
• Criteria – It is the condition that is used to count the values.

Example:

• Let’s consider the below example to create a two-way count with COUNTIFS Function.
• Refer to the below image.
• First, we will give the input values in Column C and Column D.
• Then, enter the given formula.
• Finally, it will show the results as per the given image.

Example

Verdict:

In this article, you can get to know the formulas to create a two-way summary count with COUNTIFS Function in Excel Office 365. Hope that you like this article. Kindly, drop your worthwhile feedback in the below comment section. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *and Excel Formulas *!!

Read Also:

• Excel Formulas for Calculating Age by Date of Birth ~ Easy Guide!!
• Formulas to Extract Numbers From Mixed Text String with Function!!
• Formulas to Find Sum of All Digits/Numbers in a Cell in Excel!!
• Excel Formulas to Count Long Numbers Without COUNTIF Function!!