Thread: Count/
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

and the question is?

--
HTH

Bob Phillips

"Edgar Thoemmes" wrote in message
...

=SUMPRODUCT((ZPODetails!V2:V18172<"")*(LEFT(ZPODe tails!A2:A18172,4)="3000")
)