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.

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