Page 309 - TP_IT_V1.0_C9_flipbpookl
P. 309
• Sum(): It returns the sum of the given values. For example, adding up the total amount spent on shopping in the
above sheet can be done using different ways as given below:
=Sum(E7,E8,E9,E10,E11)
OR
=Sum(E7:E11)
OR
=Sum(E7:E9,E10:E11)
OR
=Sum(E7:E10,E11)
Subject: To calculate sum
Select the cells and click on icon on the formula bar and the sum of the cells will be automatically
calculated. This is another way of adding the selected cells or using the Sum function.
• Min(): It returns the minimum value out of the given values. Let us find the minimum price of an article in the above
sheet.
=Min(D7:D11)
OR
=Min(D7,D8,D9,D10,D11)
OR
=Min(D7:D9,D10:D11)
OR
=Min(D7:D10,D11)
• Max(): It returns the maximum value out of the given values. Let us find the maximum quantity purchased in the
given sheet.
=Max(C7:C11)
OR
=Max(C7,C8,C9,C10,C11)
OR
=Max(C7:C9,C10:C11)
OR
=Max(C7:C10,C11)
• Count(): It returns the count of the number of cells that contain numeric values. Let us count the number of articles
in the given sheet.
=Count(C7;C8;C9;C10;C11)
OR
=Count(C7:C9;C10:C11)
OR
=Count(C7:C10;C11)
OR
=Count(C7:C11)
Electronic Spreadsheet 307

