I have data on two worksheets and I want to sum data on one sheet if the data
on the second sheet matches. The data in sheet one is either 4, 7, or 10
digits (and is in text format, xxxx-xx-xx) but sheet 2 is only 4 digits. I
have the formula below but it returns zero and that isnt right.

What do I need to do to fix this?

=SUMPRODUCT(--((LEFT(TRIM('sheet 1'!A2:A3000),4))='sheet 2'!B349),'sheet
1!'B2:B3000)

Thanks