Counting Blank cells using evaluate(=sumproduct)
 

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

Counting Blank cells using evaluate(=sumproduct)
 

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?

"Gwen" wrote:

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

Counting Blank cells using evaluate(=sumproduct)
 

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.

"Alok" wrote:

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?

"Gwen" wrote:

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

Counting Blank cells using evaluate(=sumproduct)
 

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.

"Gwen" wrote:

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.

"Alok" wrote:

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?

"Gwen" wrote:

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