DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Formulas to Count Multiple Criteria and OR Logic with COUNTIFS!!

This page will show the Formulas to count multiple criteria with OR Logic in Excel Office 365 Using COUNTIFS Function. You can also learn the basic syntax and its explanations. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formulas to count multiple criteria and OR logic using COUNTIFS Function
Formulas to count multiple criteria and OR logic using COUNTIFS Function

General Formula:

  • Use the below formula to count multiple criteria and OR logic in Excel.

=SUM(COUNTIFS(range,{“criteria1″,”criteria2”}))

Syntax Explanations:

  • SUM – The Excel SUM Function adds values in the cells.
  • 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:

  • The below example will show how to count multiple criteria and OR logic.
  • First, we give the input values in Column B, C , and Column D.
  • Then, enter the given formula.
  • Finally, we will get the result in the selected Cell G4.

Example
Example

Closure:

In this tutorial, we explained the formulas used for counting the multiple criteria and OR logic in Excel Office 365 with a COUNTIFS Function. Hope you like this article. If you have any doubt , then leave it in the below comment section.

Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *and Excel Formulas *!!

Read Also:

Top comments (0)