Microsoft Excel Functions & Formulas

Use the SUM and DATEVALUE functions to count

today’s sales of a specific product

The table in Figure 11-12 contains a number of products sold on dif-

ferent days. We want to count all sales of one specific product for

just one day. To handle dates this way, use the DATEVALUE func-

tion, which converts a date represented by text to a serial number.

Use an array formula to count all the sales of one product for the

desired day.

4

To count today’s sales of a specific product:

1. In cells A2:A15 list dates.

2. In cells B2:B15 enter product numbers.

3. In cell E1 enter =TODAY().

4. Select cell E2 and type the following array formula:

=SUM((DATEVALUE("11/25/06")=$A$2:$A$15)*("K7 ...