=SUMPRODUCT(--(MONTH('Month 4 July 06-07'!C$8:C$124)=6),'Month 4 July
06-07'!D$8:D$124)

This Gives me monthly summary totals
June, July .....May for the 12 months.

This is where I was finally going
Column A
=IF(MONTH('Month 4 July 06-07'!$C8)=B$2,'Month 4 July 06-07'!$A8,0)
Column B
=IF(MONTH('Month 4 July 06-07'!$C8)=+B$2,'Month 4 July 06-07'!$D8,0)


C8 is date in formate 01/06/06 etc
A8 is Code Number
D8 is Value

This gave me the Product Code and the quantity completed in month
detail.

I then copied down to C9, A9, D9 etc then sum total at bottom, month by
month for 12 months in columns C,D etc.. etc..

Thanks Bondi, I will definitely be back to this site, sat up until 3am
this morning trying to figure this one out.


--
PamelaJ
------------------------------------------------------------------------
PamelaJ's Profile: http://www.excelforum.com/member.php...o&userid=36387
View this thread: http://www.excelforum.com/showthread...hreadid=561701