Logic (1): How to count total number of Black balls made in China?

On Counting—(COUNT functions in MS EXCEL)

Question: 

How to count total number of Black balls made in China?

Answer:

Prerequisite:

1. Create  a new excel file.
2. Identify the attributes of the ball like colour, unique id, maker, weight, density, material etc.
3. Take a ball enter it's id in the first column followed by it's attributes in the specific columns.
4. Do it for all the balls one by one in a systematic manner.
5. Save the excel file onto your local system.

      Now you have a digitized version of the balls in the basket. That is the prerequisite. Please find below screen-shot of 2 columns, Column A with unique id of the ball and Column B with color of the ball.

Solution:

1. Count the total number of balls using the function “COUNTA” and select the region that needs to be counted. Refer screen-shot below.

2. Count the total number of Black balls using the function “COUNTIF”. Select the region that needs to be counted from and apply the selection criteria either by keying the criteria in a separate cell or in the formula itself. Refer screen-shot below.

3. Count the total number of Black balls made by China using the function “COUNTIFS”. Select the region that needs to be counted from and apply the first selection criteria, similarly select the next criteria region and apply the second criteria. First is to select Black balls, on which you apply the criteria “Made by China” to get the count of Black balls made by China. Refer screen-shot below. Column C has details of the Maker.

4. Results are presented in the below screen-shot.

Date and Time of Writing: 01/28/2015 13:30 PM—16:15 PM