Countifs()

Countif is used when you have multiple criteria to count in a single go.

In below example there are two columns "Region" and "Products" sold. Management wants to know how much quantity is sold in a region for a specific product. 

In the formula first you have to select Criteria1 range (Column D) then Criteria1 (cell h5) and then select Criteria2 (Column E) range then Criteria2 (cell I5). You can select any number of criteria, but sometimes if number of criteria are too many excel might crash. 

 Example:

How to add Developer Tab in Excel

Developer tab is require to see options for macros, to create macros and for macro related features.

Developer tab is just like an ordinary tab such as "Home" tab, can be added  by below 3 simple steps.

Step 1: Go to "File" tab then "Options"
Step 2: In "Options" go to "Custom Ribbon"
Step 3: To your right hand side under "Customize the Ribbon" check on developer tab and press OK.

You can now see it next to "View" tab.