consolidate and count if quantity is not zero

[Vagus]

Hello and Thank You in advance!
Column B is what I want to consolidate and count. I only want it to appear on the consolidated list If correlated column C has a value greater than zero.
[TABLE="width: 354"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 127"]
<tbody>[TR="class: grid"]
[TD="width: 127"]Bid Code[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 166"]
<tbody>[TR="class: grid"]
[TD="width: 166"]Breakdown Code[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 61"]
<tbody>[TR="class: grid"]
[TD="width: 61"]Quantity[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 127"]
<tbody>[TR="class: grid"]
[TD="width: 127"]1LPostGLLM10ft3x6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 166"]
<tbody>[TR="class: grid"]
[TD="width: 166"]GLLM 3-1/8 x 6 @ 10ft[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD][TABLE="width: 127"]
<tbody>[TR="class: grid"]
[TD="width: 127"]1LPostGLLM10ft5x8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 166"]
<tbody>[TR="class: grid"]
[TD="width: 166"]GLLM 5-1/8 x 7-1/2 @ 10ft[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD][TABLE="width: 127"]
<tbody>[TR="class: grid"]
[TD="width: 127"]2LPostGLLM10ft3x6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 166"]
<tbody>[TR="class: grid"]
[TD="width: 166"]GLLM 3-1/8 x 6 @ 10ft[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD][TABLE="width: 127"]
<tbody>[TR="class: grid"]
[TD="width: 127"]2LPostGLLM10ft5x8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 166"]
<tbody>[TR="class: grid"]
[TD="width: 166"]GLLM 5-1/8 x 7-1/2 @ 10f[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD]3LPostGLLM10ft3x6[/TD]
[TD]GLLM 3-1/8 x 6 @ 10ft[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD][TABLE="width: 127"]
<tbody>[TR="class: grid"]
[TD="width: 127"]3LPostGLLM10ft5x8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 166"]
<tbody>[TR="class: grid"]
[TD="width: 166"]GLLM 5-1/8 x 7-1/2 @ 10f[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD]4LPostGLLM10ft3x6[/TD]
[TD]GLLM 3-1/8 x 6 @ 10ft[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD][TABLE="width: 127"]
<tbody>[TR="class: grid"]
[TD="width: 127"]4LPostGLLM10ft5x8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 166"]
<tbody>[TR="class: grid"]
[TD="width: 166"]GLLM 5-1/8 x 7-1/2 @ 10f[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]7[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
Thanks again for any help.

 

[sandy666]

it looks like

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]

Bid Code​

[/td][td=bgcolor:#70AD47]

Breakdown Code​

[/td][td=bgcolor:#70AD47]

Quantity​

[/td][td]Column1[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FF00FF]1LPostGLLM10ft3x6[/td][td=bgcolor:#FF00FF]GLLM 3-1/8 x 6 @ 10ft[/td][td=bgcolor:#FF00FF]

#NAME?​

[/td][td]=ETkoBidQty("1LPostGLLM10ft3x6")[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FF00FF]1LPostGLLM12ft3x6[/td][td=bgcolor:#FF00FF]GLLM 3-1/8 x 6 @ 12ft[/td][td=bgcolor:#FF00FF]

#NAME?​

[/td][td]=ETkoBidQty("1LPostGLLM12ft3x6")[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FF00FF]1LPostGLLM4ft3x6[/td][td=bgcolor:#FF00FF]GLLM 3-1/8 x 6 @ 4ft[/td][td=bgcolor:#FF00FF]

#NAME?​

[/td][td]=ETkoBidQty("1LPostGLLM4ft3x6")[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#FF00FF]1LPostGLLM6ft3x6[/td][td=bgcolor:#FF00FF]GLLM 3-1/8 x 6 @ 6ft[/td][td=bgcolor:#FF00FF]

#NAME?​

[/td][td]=ETkoBidQty("1LPostGLLM6ft3x6")[/td][/tr]
[/table]

 

[Vagus]

I removed the formulas and populated with some integer values.
The second set of data (green headers) on the second sheet represents the final product I am looking for out of excel.
https://drive.google.com/open?id=1zmhZB7dU0anAR9VCCFbPw6VaTZSW9b4EU5D2RJ13mAM

 

[sandy666]

here is the result
https://1drv.ms/x/s!AopTvf3RGAN5kBDeEQxpsEsdX0_h

M code

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Bid Code", type text}, {"Breakdown Code", type text}, {"Quantity", Int64.Type}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Quantity] <> 0)),
    #"Grouped Rows" = Table.Group(#"Filtered Rows", {"Breakdown Code"}, {{"Sum", each List.Sum([Quantity]), type number}}),
    #"Sorted Rows" = Table.Sort(#"Grouped Rows",{{"Breakdown Code", Order.Ascending}})
in
    #"Sorted Rows"

to do that you'll need PowerQuery (Excel 2010/2013 add-in, 2016 built-in)