Hi

One way, in cell B2 of Sheet2 enter
=SUMPRODUCT(--(Sheet1!$A$2:$A$20900)=A2),--(Sheet!$E$2:$E$20900=B$1),$C2:$C20900)
Copy across for the required number of columns.
Copy the set of formulae down for the range of Values in column A.

Better still would be to use a Pivot table on your data on Sheet1.
For help on setting up Pivot tables take a look at
http://peltiertech.com/Excel/Pivots/pivotstart.htm
and
http://www.contextures.com/xlPivot02.html

--
Regards

Roger Govier


"Cube Farmer" wrote in message
...
A B C D E F
1/06 2/06 3/06 4/06
1 ford
2 chey
3 dodge


OK, on another sheet I have 20,900 lines of items I have sold to these
customers.
I have the cust name in column A, the date as listed in row 2 is in
column
E, and the number of pcs sold is in column C. I want to get the total
amount
sold to each cust during each month. Any help would be great.