forgot to add i've now upgraded to office 2010. Will try the sumifs thank you