# Personal Career & Learning Guide for Data Analyst, Data Engineer and Data Scientist

Excel is a popular spreadsheet software that is widely used by data analysts for organizing, storing, and analyzing data. One of the common tasks for a data analyst is to count the number of rows that meet certain criteria. In this article, we will discuss how to count the rows with OR logic in Excel.

An OR condition in Excel is used to find the rows that meet at least one of the specified criteria. In other words, it returns all the rows that match either of the conditions. For instance, if you have a list of products and you want to find the number of products that are either red or blue, you can use an OR condition to count the number of rows that meet either of the two criteria.

To count the number of rows that meet an OR condition, you can use the SUMPRODUCT formula. This formula is a combination of two functions – SUM and PRODUCT. The SUM function adds up the values, while the PRODUCT function multiplies the values. The SUMPRODUCT formula allows you to perform both of these operations at the same time.

Here’s how you can use the SUMPRODUCT formula to count the rows with OR logic in Excel:

1. Select a cell where you want to display the result of the formula.
2. Enter the SUMPRODUCT formula, followed by an opening and closing bracket: =SUMPRODUCT().
3. In between the brackets, enter a set of parentheses that define the conditions. For example: (A1=”red”)+(A1=”blue”).
4. The formula will return the number of rows that meet either of the two conditions.
5. To apply the formula to the entire column, select the cell with the formula and drag the fill handle down to the end of the column.

It’s important to note that the SUMPRODUCT formula only works with numbers, so if you have text or date values in your data, you need to convert them to numbers first. You can use the IF function to perform this conversion.

In conclusion, counting the number of rows that meet an OR condition in Excel is a common task for a data analyst. The SUMPRODUCT formula is a simple and efficient way to achieve this goal, and it allows you to perform the calculation quickly and accurately. With a little bit of practice, you’ll be able to master the formula and apply it to your own data analysis tasks.

# Excel Example for Data Analyst – Count rows with OR logic

Loading...
Taking too long?

Reload document
| Open in new tab

Download PDF [483.39 KB]

# Personal Career & Learning Guide for Data Analyst, Data Engineer and Data Scientist

## Applied Machine Learning & Data Science Projects and Coding Recipes for Beginners

A list of FREE programming examples together with eTutorials & eBooks @ SETScholars

# Projects and Coding Recipes, eTutorials and eBooks: The best All-in-One resources for Data Analyst, Data Scientist, Machine Learning Engineer and Software Developer

Topics included: Classification, Clustering, Regression, Forecasting, Algorithms, Data Structures, Data Analytics & Data Science, Deep Learning, Machine Learning, Programming Languages and Software Tools & Packages.
(Discount is valid for limited time only)

`Disclaimer: The information and code presented within this recipe/tutorial is only for educational and coaching purposes for beginners and developers. Anyone can practice and apply the recipe/tutorial presented here, but the reader is taking full responsibility for his/her actions. The author (content curator) of this recipe (code / program) has made every effort to ensure the accuracy of the information was correct at time of publication. The author (content curator) does not assume and hereby disclaims any liability to any party for any loss, damage, or disruption caused by errors or omissions, whether such errors or omissions result from accident, negligence, or any other cause. The information presented here could also be found in public knowledge domains.`

# Learn by Coding: v-Tutorials on Applied Machine Learning and Data Science for Beginners

Please do not waste your valuable time by watching videos, rather use end-to-end (Python and R) recipes from Professional Data Scientists to practice coding, and land the most demandable jobs in the fields of Predictive analytics & AI (Machine Learning and Data Science).

The objective is to guide the developers & analysts to “Learn how to Code” for Applied AI using end-to-end coding solutions, and unlock the world of opportunities!