SUMIF and joining multiple tables

[david20100]

Hi,

I need to join multiple table and arrange data correctly.  I need to find the production number (rdenum) = production number (prenum) in 2 table and sum the work done (sumif) (see the complete example in the workflow)

To be able to get all data on the same line

Production - product - qty - end date - manpower - total punch time etc

Table 1

rdenum	rderec	rdeqte	rdedpp	rdestat
057703	CA-200	12	2018-01-11	P
057704	CA-200	12	2018-02-12	P
057705	CA-200	12	2018-03-08	P
057706	CA-200	12	2018-04-03	P
057707	CA-200	12	2018-05-07	P
057778	CA-200	12	2018-05-28	P

Table 2

predat	preemp	prenum	premod	premodh
2018-01-08	0664	057703	MOD-SOUDURE	7,25
2018-01-08	0664	057703	MOD-SOUDURE	0,25
2018-01-10	0775	057704	MOD-SOUDURE	4
2018-01-10	0775	057704	MOD-SOUDURE	0,75
2018-01-11	0775	057704	MOD-SOUDURE	8,75
2018-01-11	0706	057704	MOD-USINAGE	1,75
2018-01-12	0775	057704	MOD-SOUDURE	5
2018-01-15	0775	057704	MOD-SOUDURE	8,75

Thanks

[cmcclellan · Accepted solution]

I don't quite understand the requirements, but does this help ?

If not, let me know what you are expecting.

[david20100]

Yes sorry i mix 2 issues i have but that cannot be resolved in 1 shot.  The part you did is exactly what i need for first issue, i will be able to handle the second one

thanks alot