Microsoft Excel Functions & Formulas

Use the SUM function to count today’s sales of

a specific product

This example is similar to the previous one, except the search cri-

teria are variable. The array formula refers now to cells E1 and E2

and sums up all counted sales for one product on a specified date in

cell E4.

4

To count sales of a specific product for one day:

1. In cells A2:A15 list dates.

2. In cells B2:B15 enter product numbers.

3. Select cell E1 and enter the desired date to be considered

for counting.

4. Select cell E2 and select one product number.

5. Select cell E4 and type the following array formula:

=SUM((E1=$A$2:$A$15)*(E2=$B$2:$B$15)).

6. Press <Ctrl+Shift+Enter>.

290

Chapter ...