sumif or something

[John]

Hello,
Got two sheet with the following data:

Sheet1 Sheet2
A B A
0010711463 29 0010711463 sumif(
0010701463 15
0010711463 10
0000711463 45

I need a function that looks to the first three digits, second third digits
and last four digits, sum if the three sets of digits are equals, if not
bring back an error.
Please find me logic to this madness…

 

[Max]

In Sheet2,

Try in B1:
=SUMIF(Sheet1!A:A,A1,Sheet1!B:B)

If you get zero, that means the numbers in Sheet1!B:B are text. Just copy a
blank cell, then select col B in Sheet1, do a right-click > paste special >
add > ok. This should suffice to convert the text numbers to real numbers,
and you should get the correct return from the SUMIF.