Many thanks for that Tom, works a treat!

I'm fairly new to macros, but I should be able to read up on Sumif an
modify the code accordingly, if for example, the range doesn't start i
A1, or I need the search word (eg. "petrol") to be be specified in
cell, shouldn't I?

Thanks again for your help, very much appreciated.

Kind regards

Nei

--
Message posted from http://www.ExcelForum.com