Asking

[iqbalmonna]

If line A have 3 style and manpower are same for this 3 style
Line B have 2 style and manpower are same for this 2 style
Line C have 4 style and manpower are same for this 4 style
Now I need to sum the manpower for this three lines only use 1 time.For below sheet answer should be A=57 + B=57 + C=38 Total 152

 

[ExceLoki]

here's 2 ways:

Book1
	A	B	C	D	E	F
1	line	style	manpower		a	57
2	a	3209422	57		b	57
3	a	3207521	57		c	38
4	a	3207722	57		total	152
5	b	3207421	57
6	b	3207521	57
7	c	3223720	38		total	152
8	c	1003025	38
9	c	3227521	38
10	c	1607761	38
Sheet1

Cell Formulas
Range	Formula
F1:F3	F1	=VLOOKUP(E1,$A$2:$C$10,3)
F4	F4	=SUM(F1:F3)
F7	F7	=SUM(VLOOKUP(UNIQUE(A2:A10),$A$2:$C$10,3))