Just tweak the LEFT part of it:
=SUMPRODUCT(('Consolidated Report'!J5:J8941="NON ASCII; NON PRINTABLE;
NULLS; CARRIAGE CONTROL")*('Consolidated
Report'!A5:A8941<"Open")*(LEFT('Consolidated Report'!E5:E8941,6)="R12741"))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"Foad" wrote:
I am using this formula and and it does not seem the syntax is correct:
=SUMPRODUCT(('Consolidated Report'!J5:J8941="NON ASCII; NON PRINTABLE;
NULLS; CARRIAGE CONTROL")*('Consolidated
Report'!A5:A8941<"Open")*('Consolidated Report'!LEFT(E5:E8941,6) = "R12741"))