Search This Blog

Sunday, February 1, 2015

Logic (2): How much do all the Red balls made of Cast Iron weigh?

On Summing—(SUM functions in MS EXCEL)

Question: 

How much do all the Red balls made of cast iron weigh?

Answer:

Prerequisite:

1. Create  a new excel file.
2. Identify the attributes of the ball like color, 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. That is the prerequisite. Please find below screen-shot of 4 columns with the unique id of the ball, color of the ball, type of the material and it's weight, in sequence.

Solution:
1. Sum the weight of all the balls using the function “SUM”. Select the region that needs to be summed. Refer screen-shot below.
 2. Sum the weight of the RED balls alone using the function “SUMIFS”. The region to be summed will be the same, in addition select the criteria region and apply the selection criteria in a separate cell. Refer screen-shot below.
 3. The same “SUMIFS” function can be used to sum the weight of all the Red balls made of cast iron alone, by including additional criteria. Refer screen-shot below.
 4. Results are presented in the below screen-shot.
 
 Date and Time of Writing: 02/01/2015 10:30 AM—12:23 PM

No comments:

Post a Comment