sumif or something
 

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€¦

sumif or something
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"John" wrote:
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€¦