Try this in B1 of Sheet2:

=IF(COUNTIF(Sheet1!B1:B100,A1)=0,"",SUMPRODUCT((Sh eet1!
B1:B100=A1)*(Sheet1!A1:A100)))

Assumes you have 100 items on Sheet1 - adjust to suit.

Hope this helps.

Pete

On Apr 2, 2:56 pm, wrote:
Hi

I need to create a formula for the following: - on one sheet i Have a
group of part number

1 123456
6 123456
7 123456
1 456789
3 789123
4 789123

On another sheet I have a table the part numbers, wanting the gross
qty sold over then month

123456 ?
456789 ?
789123 ?

and i need to be about to automatically add them all up at once, and
also (to top it off) leave the cells blank of the parts numbers not
sold.

Can anyone help, my head is spinning :-)

Regards

Linexe