=sumproduct() likes to work with numbers. the -- changes trues and falses to
+1's and 0's.

I'd guess that there was something wrong with your formula.

You may want to post your =countif() (with the other workbook open) and your
=sumproduct() version, too.



Egon wrote:

Well, I tried your suggestion of using SUMPRODUCT and it doesn't do the
same thing as count if, unless I'm not understanding how you have the
formula written...

what's the "(--(" piece?

J.

--

Dave Peterson