Hi Guys:
Here's my dilemma:

I have a flat file (example follows):

Orders

          A              B            C

1     Client     Product     Quantity

2     Jim          Green        23

3     Sam         Blue          76

4     Jim           Blue          13

5     Jim           Green        54

.

.

.

I would like to create a matrix that looks like this:

Totals

        A              B             C           D

1                    Green       Blue       Red

2      Jim             77           13

3      Sam                           76

4      Jane

Is there a single formula that I can place is "Totals B2" that can give me
the desired results? The first thing that came to mind is SUMIF, but I haven
't figured out how to make it work.

Any assistance would be greatly appreciated,

Craig