Adrian

I don't believe that this can be done.

Have a look at
http://www.excelforum.com/showthread...ght=sumproduct

There is some discussion of the problem, and some alternatives.


rylo