Eliminate duplicates in one column while totaling value from another

[Semperfi4Life83]

Hi,

I am trying to eliminate duplicates from column "D" while totaling the values entered in column "F" in snippet below. I want to show just one WO # but the total number of hours .

The end result should be for example:

• 21_047963 = 3.0
• 22_060044 = 14
• 22_060048 = 13

Appreciate any thoughts on a way to not do this manually!

James

 

[AlanY]

try this

Book1
	A	B	C	D	E
1	WO	Hrs		WO	Hrs
2	1	1		1	3
3	1	1		2	4
4	2	1		3	2
5	2	1
6	2	1
7	1	1
8	2	1
9	3	1
10	3	1
Sheet1

Cell Formulas
Range	Formula
D2:D4	D2	=UNIQUE(A2:A10)
E2:E4	E2	=SUMIF($A$2:$A$10,D2,$B$2:$B$10)
Dynamic array formulas.

 

[Semperfi4Life83]

@AlanY - Appreciate the help on this. I tested it on my file and works perfectly.

Thanks,
James

 

[AlanY]

you're welcome.
glad that works for you