State Distributor

State Distributor

Start with the Excel workbook (spreadsheet) State Distributer

–

start.xlsx.

This data shows data on 133 sales. In column B, the State in which the sale occurred is

displayed; in column C, the product for which the sale occurred is displayed; in column D,

the amount of the sale is displayed.

In the range G1:L5, you will see the first matrix that you will need to summarize with a

COUNTIFS statement. Executing this statement correctly will produce a numeric count of

the transactions that occurred between the

state distributer and the product line.

In the range G7:L11, you will see the second matrix that you will need to summarize with a

SUMIFS statement. Executing this statement correctly will produce a total in terms of the

total amount that has occurred bet

ween the state distributer and the product line.

In the range G

13

:L1

7

, you will see the

third

matrix that you will need to summarize with a

AVERAGEIFS statement. Executing this statement correctly will produce an average

transaction amount that has occurr

ed between the state distributer and the product line.

HINT: Be very careful about what cell references are absolute and which are mixed (the row

or column absolute and the other relative).