Dave,
thank you, yes that did the trick...I had the sumproduct function wrong, I
was using "=XA" not ="XA" - an important difference.


The solution you provided works provided I subtract for blank spaces. I have
to treat 0 and blank cells separately ( 0 is a possible outcome whereis blank
is no data available).

Thanks very much

Phil