sumif or something

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 05 Apr 2007 09:12 GMT

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…

Reply to this Message

Max - 05 Apr 2007 09:34 GMT

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.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hello,
> Got two sheet with the following data:
[quoted text clipped - 10 lines]
> bring back an error.
> Please find me logic to this madness…

Reply to this Message