Thread: Why an error?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 216
Default Why an error?

Hi. Can you tell me why I am getting an error with the
following statement? If I take the same formula and plug
it into the worksheet, it works fine.


Range("C9").Formula = "=SUMPRODUCT(--(Dec!A6:A20J3),--
(Dec!A6:A20<K3),--(Dec!B6:B20<""))"

Thanks,
Mike.