In this article, we will learn about how to count specific row in excel.
To count values having conditions, use the COUNTIFS function. We can count the rows having multiple conditions. So let's see the syntax for the COUNTIFS function in excel.
Excel provides COUNTIFS function that counts on multiple conditions.
Range1 : first range for criteria1.
Criteria1 : criteria from range1.
Range2 : range for criteria2. Optional.
Criteria1 : criteria from range2. Optional.
Let's make a formula using the above functions:
Firstly, we need to generalize the formula for all users who can use it for their purposes.
The above matches all values in column A having value1 and column having value2 and column C having value3 and so on. Then it counts all the rows having all value1, value2, value 3 and so on.
This all might be confusing. So Let’s use the formula in an example to get its more understanding.
Here we have table_array and We need to find the count the values in the list having 2 conditions:
We need to find the row count using the below formula
Use the formula:
The function matches value in F4 ( Joe ) with column A. And then matches the value in F5 ( North ) with column B.
So the function returns the count of rows having both conditions.
As you can see the formula returns the value for two given conditions.
That's all about, how to Count specific rows in excel. Explore more articles on Excel Formulas here. Please feel free to state your query or feedback for the above article.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.