Mallycat wrote:
You could try using =sumif to sum all the totals for each type.


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=561674

I think you must have sent it to me telepathically first LOL

Works perfectly, cheers