Thanks for the replies to my last post re: SumIfAnd.
Just one other issue that has been bugging me for ages . .
How is it possible to lookup and return a value using reference to a row value AND a column value (in effect VLOOKUP plus HLOOKUP). Would this be possible using a form of array vector??