View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Kirill V Kirill V is offline
external usenet poster
 
Posts: 5
Default ISNUMBER Logical test

Joel, logically, this is exactly what i need, but formula doesnt work,
gives me #VALUE...

This is your formula.... any ideas?

=SUMPRODUCT(--(OR(LEFT($B$2:$B$60,3)="312",LEFT($B$2:$B$60,3)="3 13")),--
($K$2:$K$60="*ct08*"),--($R$2:$R$60000="B60"),$H$2:$H$60)

*** Sent via Developersdex http://www.developersdex.com ***