Sandy sorted this out with sumproduct. I'll also try the possible
solution above too (again form Sandy), to see if it works or to see
how I might use this method in the future.

many thanks,
Matt