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