Thanks for all your help on this!

I have done what Mangesh suggested and this has worked, dont know how
but im very happy it does.

That is one part out of the way, Would there be a a way that a macro
could be written to identify each uniquie 7 digit product code and
apply the =mysum(A9,"L") formula?

This was i would have to manualy enter the formula as i have alot of
data to do this for.

Paul


--
pauldaddyadams
------------------------------------------------------------------------
pauldaddyadams's Profile: http://www.excelforum.com/member.php...o&userid=22499
View this thread: http://www.excelforum.com/showthread...hreadid=393228