sumif or something

J

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…
 
M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top