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

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

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

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