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
|