Need Help

[suthrnboy19]

<TABLE style="WIDTH: 164pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=218 border=0><COLGROUP><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width=90><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl63 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; WIDTH: 68pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffffcc" width=90 height=17>000040424</TD><TD class=xl64 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #ffffcc" width=64>2.0</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #ffffcc" width=64>D</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl63 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffffcc" height=17>000040424</TD><TD class=xl64 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #ffffcc">2.0</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #ffffcc">D</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl63 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ffffcc" height=17>000040424</TD><TD class=xl64 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #ffffcc">1.0</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #ffffcc">K</TD></TR></TBODY></TABLE>

These are my columns. Column A is a Job number. Column B is hours that it took to complete job. Column C is whether the job was (D)discarded or (K) keep. this is just one example of a spead sheet i have with hundreds of different job numbers(column A). I need to find a way to identify all similar job numbers(A) that have both K and D in column C. Then i want to find a way to add up hours for all discarded jobs(D) that were identified> Please help. Im stumped.

 

[texasalynn]

Welcome to MrExcel Board....

sounds like a pivot table would work, here is a sample

Excel Workbook
	A	B	C	D
3	Sum of Hours	D or K
4	Job Number	D	K	Grand Total
5	40424	4	1	5
6	Grand Total	4	1	5
Sheet4

 

[btadams]

Sounds like you need to make a pivot table. There are plenty of tutorials around if you need help.