I dont how to write this.
Please look at cell I22 it sums up in that column BUT if you look at cell J22 thats the correct answer because Employees 4000 & 4535 worked together as a crew. So reality thoses employess you see there in my example produce only 759 Qty. This is a sample data. My data fluctuates.
If anyone knows how to sum up the data but exclude duplicates vaules ?
Please look at cell I22 it sums up in that column BUT if you look at cell J22 thats the correct answer because Employees 4000 & 4535 worked together as a crew. So reality thoses employess you see there in my example produce only 759 Qty. This is a sample data. My data fluctuates.
If anyone knows how to sum up the data but exclude duplicates vaules ?
Needs SUM(IF(Frequency.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Last | First | STD | Actual | Crew | |||||||
2 | SHIFT | Clock | Name | Name | Product# | Oper.# | Oper.# | Size | Qty | |||
3 | 1 | 2107 | SALDIVAR | ROB | 753984-0002 | 400915 | 400915 | 1 | 16 | |||
4 | 1 | 2107 | SALDIVAR | ROB | 753984-0003 | 400915 | 400915 | 1 | 8 | |||
5 | 1 | 2107 | SALDIVAR | ROB | 753984-0001 | 400915 | 400915 | 1 | 7 | |||
6 | 2107 Total | |||||||||||
7 | ||||||||||||
8 | ||||||||||||
9 | 2 | 4475 | SOLIS | DAVID | K272-188 | 400910 | 400910 | 1 | 40 | |||
10 | 2 | 4475 | SOLIS | DAVID | K058-519R | 400910 | 400910 | 1 | 10 | |||
11 | 4475 Total | |||||||||||
12 | ||||||||||||
13 | 2 | 4000 | CASTILLO | JEFF | 442733-0011 | 400820 | 400815 | 2 | 80 | |||
14 | 2 | 4000 | CASTILLO | JEFF | 449614-0002 | 400815 | 400820 | 2 | 467 | |||
15 | 2 | 4000 | CASTILLO | JEFF | 407657-0003 | 400820 | 400820 | 2 | 131 | |||
16 | 4000 Total | |||||||||||
17 | ||||||||||||
18 | 2 | 4535 | CASTILLO | MATT | 442733-0011 | 400820 | 400815 | 2 | 80 | |||
19 | 2 | 4535 | CASTILLO | MATT | 449614-0002 | 400815 | 400820 | 2 | 467 | |||
20 | 2 | 4535 | CASTILLO | MATT | 407657-0003 | 400820 | 400820 | 2 | 131 | |||
21 | 4535 Total | |||||||||||
22 | 1437 | 759 | ||||||||||
23 | ||||||||||||
Sheet1 |