Microsoft Excel Functions & Formulas

Use the DSUM function to sum all prices of a

category that are above a particular level

The list in the following figure shows the prices of a number of

goods in different categories. To sum up all prices in one category

that are above a particular price, use the DSUM function. Here we

will sum up all prices of category A that are above $100.

4

To sum all prices of category A above $100:

1. Copy to a worksheet cells A1:C10 as shown in Figure 8-10.

2. Copy range A1:C1.

3. Select cell A12 and press <Ctrl+V>.

4. In cell B13 enter A to search inside category A.

5. In cell C13 type the argument >100.

6. In cell D15 type the following formula:

=DSUM(A1:C10,C1,A12:C13) ...