i'll check out the sum product function - thanks for the suggestion.

doing it manually with a pivot table and some tweaking afterwards, is very easy and gives me the format that the 'table' has always been in (its for one of our directors, so i didn't really want to change the format.

its a shame this forum doesn't allow embedding of files, otherwise i'd show you what I have and what I need to acheive!!