Microsoft Excel Functions & Formulas

Use the SUM function to count numbers from

x to y

For this tip, we want to count all sales from $2500 to less than

$5000. As previously described, COUNTIF handles only one condi-

tion. Use an array formula with the SUM function to get the correct

result here.

4

To count sales from $2500 to less than $5000:

1. In cells A2:B11 list the daily sales and dates.

2. Select cell D2 and type the following array formula:

=SUM((A2:A11>=2500)*(A2:A11<5000)).

3. Press <Ctrl+Shift+Enter>.

4. Select cells A2:B11.

5. On the Format menu, click Conditional Formatting.

6. Select Formula Is and type the following formula:

=AND($A2>=2500,$A2<5000).

7. Click Format.

8. In the P