Formulaes and Functions - Sumif

The sumif function will allow the user to total / add / sum a group of cells that fulfil certain criteria.  In the example used, the aim is to total / add / sum the Prices of just the Software in the Ware or first column. 

Information about the sumif function can be found in Excel in the Help menu / Index / Sumif.   The following example will illustrate similar work.

sumif11.jpg (99978 bytes)

This work may be freely copied for non-commercial use only. Copyright Pam Miller