=SUMPRODUCT((ZPODetails!V2:V18172<>"")*(LEFT(ZPODetails!A2:A18172,4)="3000"))
E Edgar Thoemmes Jan 18, 2005 #1 =SUMPRODUCT((ZPODetails!V2:V18172<>"")*(LEFT(ZPODetails!A2:A18172,4)="3000"))
B Bob Phillips Jan 18, 2005 #2 and the question is? -- HTH Bob Phillips =SUMPRODUCT((ZPODetails!V2:V18172<>"")*(LEFT(ZPODetails!A2:A18172,4)="3000") )
and the question is? -- HTH Bob Phillips =SUMPRODUCT((ZPODetails!V2:V18172<>"")*(LEFT(ZPODetails!A2:A18172,4)="3000") )
