" wrote:
=SUMPRODUCT(--(LEFT('Data'!B1:B500,3)="xyz"),--(IF('Data'!F2:F50027,1,0)))
It returns #VALUE ...

One guess ..

Perhaps try correcting it to ensure that the 2 ranges are identical in size:
'Data'!B1:B500 is not equal in size to 'Data'!F2:F500
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---