Hi guys, I need your help...

I have 3 columns named LongCol, B and Amount

i want to add Amount if LEFT(LongCol,3) = B5 ie if the first 3 digits of LongCol is equal Cell B5

I have tried this but it did not work:

=SUMIF((LEFT(LongCol,3),B5,Amount)).

please help

I