Counting Blank cells using evaluate(=sumproduct)

[Guest]

Please somebody, tell me why this doesn't work.
I am using version 2003.

Evaluate("=sumproduct((F25:f136=""abc"")*(j24:j136=""))")

I have used the below directly in the worksheet and it works fine.
{=sum((F25:f136=""abc"")*(j24:j136=""))}

Please assist.
Thanks

 

[Guest]

Gwen,

There are unequal number of elements in the two arrays. Is that the problem
or is this an error that crept in while posting to the newsgroup?

 

[Guest]

No, that is not the problem.
The array elements are correct in my code. It should be
Evaluate("=sumproduct((F25:f136=""abc"")*(j25:j136=""))")

Thanks.

 

[Guest]

I think what you need is
Evaluate("=sumproduct(--(F25:f136=""abc"")*--(j25:j136=""""))")
This is because inside the double quotes, two double quotes become one
double quote.