Formulas for Counting Non-Contiguous Range in Excel Using COUNTIF!!

This article will show the formulas for counting the non-contiguous range with criteria in Excel Office 365 using the COUNTIF Function. From this article, you can also learn the basic syntax and its explanations. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formulas to count non-contiguous range in Excel

General Formula:

• The below formula will help to count the non-contiguous range in Excel.

=SUM(COUNTIF(INDIRECT({“range1″,”range2″,”range3”}),criteria))

Syntax Explanations:

• SUM – The Excel SUM Function adds values in the cells.
• COUNTIF – In Excel, this function will help to count the number of cells that meet a single condition or criteria.
• INDIRECT – It will return a valid reference from a given text string. Read more on the INDIRECT Function.
• 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 see the below example to count the non-contiguous range.
• First, you need to give the input values.
• In the below image we will give the input ranges in Column B , Column D , and Column F.
• After that, apply the given formula in the formula bar section.
• Finally, we get the result in Cell I5.

Example

Conclusion:

From this article, you can get to know the formulas for counting the non-contiguous range with criteria in Excel Office 365. I hope that this article is useful to you. If you have any suggestions, feel free to share it with us.

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

Read Also:

• Excel Formulas to Count Unique Numeric Values with Criteria!!
• Formulas for Counting Unique Values in a Range with COUNTIF in Excel!!