WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » COUNTIF with Multiple Criteria

COUNTIF with Multiple Criteria

COUNTIF with Multiple Criteria in Excel

Countif with multiple criteria method in excel can be used with the concatenation operator or & operator in criteria or the or operator as required.

Method #1: Using the SUM with COUNTIF Function.

  • Step 1: Copy the below data to your excel sheet.

Using SUM With COUNTIF function 1

  • Step 2: Apply the below SUM formula with COUNTIF to get the total count of Paseo & Montana.

Using SUM With COUNTIF function 1-1

And the result will be as per the below image.

Using SUM With COUNTIF function 1-2

Now I will break down the formula. The formula I have used here is

Using SUM With COUNTIF function 1-3

  • Part 1: As per the formula, our range to count the product is from C2:C25.
  • Part 2: If we are counting only one criterion, we just mention our criteria in double quotes (“Paseo”). Since we are counting multiple criteria, we need to mention curly brackets before we mention our criteria.
  • Part 3: Now, the SUM function plays its part in returning the result. The countif formula returns the count for Paseo (8) and the count for Montana (10). The sum will add Paseo (8) + Montana (10) and returns the result as 18.

Method #2: Using Double COUNTIF Function with Multiple Criteria.

  • Step 1: Copy the below data to your excel sheet.

Using Double COUNTIF function 1

  • Step 2: Apply the below formula to get the total of Paseo & Montana.

Using Double COUNTIF function 1-1

And the result will be as per the below image.

Using Double COUNTIF function 1-2

Here I have used two COUNTIF functions with multiple criteria to get the total count of two products. And the formula I have used here is

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Using Double COUNTIF function 1-3

  • Part 1: This is the normal COUNTIF formula excel to count the total count for the Paseo product.
  • Part 2: This is the normal COUNTIF formula excel to count the total count for the Montana product.

Part 1 returns eight as a result and Part 2 returns ten as a result. Plus (+) symbol adds these two numbers and returns the result as 18.

You can download this COUNTIF with Multiple Criteria Template here – COUNTIF with Multiple Criteria Template

COUNTIF with Multiple Criteria – Another Example

Now we will see the total count between two numbers. Consider the below numbers and find the total numbers count in between 1000 and 2000.

COUNTIF Function with Multiple Criteria 1

Again, we need to apply two COUNTIF formulas to get the total.

COUNTIF Function with Multiple Criteria 1-1

In this formula, the first formula helps us to find the values greater than 1000, and the second formula enables us to find the values greater than 2000. Once we get the result, we deduct the first formula value with the second formula value.

  1. First Formula Result = 12
  2. Second Formula Result = 5
  3. Result = A – B
  4. Result = 7

Therefore, the total number count of numbers between 1000 and 2000 is 7. In this way, we can use the COUNTIF function with multiple criteria.

Recommended Articles

This has been a step by step guide to COUNTIF with multiple criteria. Here we discuss how COUNTIF works with multiple criteria (using SUM and Double Countif) along with examples and downloadable excel templates. You may also look at these useful excel tools –

  • SumIf with Multiple Criteria
  • SUM Formula in Excel
  • COUNTIF Examples
  • How to use SMALL Function in Excel?
  • Remove Leading Spaces in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download COUNTIF with Multiple Criteria Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More