"Mary-Lou" wrote:
I tried it both ways - same results.

Perhaps you could paste the actual formula you're using ??
(assume you've adapted it)

In adapting to suit, pl note that entire col references (eg: A:A, B:B)
cannot be used in SUMPRODUCT, and the ranges used should be identical in
size, eg: $A$1:$A$1000, $B$1:$B$1000
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---