View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gwen Gwen is offline
external usenet poster
 
Posts: 54
Default 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