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:
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:
No comments:
Post a Comment