Microsoft Excel Functions & Formulas

Use the HLOOKUP function to determine sales

for a particular day

In this example, all sales for a certain day have to be listed in the

first column of a table. In addition, all sales have to be summed up

in cell A7 to show the total amount of sales for this day.

4

To determine the total amount of sales for one day:

1. In a worksheet, copy the information in cells C1:G5, as

shown in Figure 9-8.

2. Enter in cell A1 the desired day for which the sales of each

team have to be listed.

3. Select cells A2:A5 and type the following formula:

=HLOOKUP($A$1,$D$1:$G$5,(ROW())).

4. Press <Ctrl+Enter>.

5. Select cell A7 and type the following formula:

="SUM="&TEXT(SUM(A2:A5),"$#,000.00") ...