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
   304   305   306   307   308   309   310   311   312   313   314