{"id":29874,"date":"2023-07-14T14:07:13","date_gmt":"2023-07-14T12:07:13","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=29874"},"modified":"2024-03-22T18:24:40","modified_gmt":"2024-03-22T17:24:40","slug":"countif-with-or-logic-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/countif-with-or-logic-in-excel\/","title":{"rendered":"3 Simple Methods to Explore the Power of COUNTIF with OR Logic in Excel"},"content":{"rendered":"

\"3<\/a><\/p>\n

Excel is a very versatile and powerful tool<\/strong> used for data analysis, calculation, and manipulation. One of the most used functions is COUNITF<\/strong><\/a> in Excel which enables cell counting based on specific conditions<\/strong>. The integration of the COUNTIF with OR operator <\/strong>enhances the function’s flexibility, making it even more powerful.<\/p>\n

COUNTIFS<\/strong><\/a> can be used when we are dealing with multiple conditions but it uses the AND<\/strong> logic i.e. it will count the cells only when all the conditions are met. What if we want to count the cells even if at least one criterion is met<\/strong>? This is where COUNTIF with OR comes to our rescue.<\/p>\n

In this article, we will be exploring the different ways of applying the COUNTIF with OR logic –<\/p>\n

Let’s look at each of these one by one.<\/p>\n

Download the Excel Workbook below to follow along and understand How to Use the COUNTIF with OR logic in Excel <\/strong><\/h4>\n

download excel workbook<\/strong><\/span>COUNTIF-with-OR.xlsx<\/span><\/a><\/p>\n

 <\/p>\n

Count cells using a + sign<\/span><\/strong><\/p>\n

The easiest way is to count the values individually<\/strong> and then use a plus (+) sign<\/strong> to add them together.<\/p>\n

=COUNTIF(range, critera1) + COUNTIF(range, criteria2)<\/strong><\/p>\n

Let’s use an example to understand better.<\/p>\n

In this example, we have a table containing the results of a marathon race<\/strong>. Column A contains the names of the competitors, column B is their respective districts, and column C is whether they completed the race or did not complete the race.<\/p>\n

We want to find out how many competitors are from Wellington and Waterloo<\/strong>. We will be using COUNITF to individually count the cells for each criterion and then add them together. The formula<\/a> will be:<\/p>\n

=COUNTIF(B2:B25,F1)+COUNTIF(B2:B25,F2)<\/strong><\/p>\n

\"3<\/a><\/p>\n