hi Thermalman,

on Sheet2
put in cell B2:B13: 1900-01-01 - 1900-02-01 - 1900-03-01 - etc.. Format "mmm"
put in cell A2:Ax : Supplier
in cell B2: the formula:
=SUMPRODUCT(--(Sheet1!$D$1:$D$20=$A2)*(MONTH(Sheet1!$C$1:$C$20)= MONTH(B$1))*(Sheet1!$B$1:$B$20))

--
isabelle



Le 2012-02-02 16:46, thermalman a écrit :
Hi, I have an Excel Spreadsheet that has the following columns
Part No - Quantity Rejected - Date Rejected - Supplier
1234 1 01/01/2012 Joes Hardware
2345 3 12/02/2012 Freds Spares
1378 5 19/03/2012 Rocky Spar1900-02-01es


I want to write a function that will return a figure into another
worksheet that has a column for each month and i want it to give the
quantity Rejected by Supplier and by Month

Supplier JAN - FEB- MAR - APR
Joes Hardware 1
Freds Spares 3
Rocky Spares 5

Can anybody tell me if this is possible and give me some idea as to how
to write the formula.. I am quite a newbie to Excel functions.

Sorry but the 1 should be under Jan, 3 under Feb and the 5 under Mar.

Regards
Thermalman