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.

Bid Code <tbody> </tbody> Breakdown Code <tbody> </tbody> Quantity <tbody> </tbody> 1LPostGLLM10ft3x6 <tbody> </tbody> GLLM 3-1/8 x 6 @ 10ft <tbody> </tbody> 0 1LPostGLLM10ft5x8 <tbody> </tbody> GLLM 5-1/8 x 7-1/2 @ 10ft <tbody> </tbody> 3 2LPostGLLM10ft3x6 <tbody> </tbody> GLLM 3-1/8 x 6 @ 10ft <tbody> </tbody> 1 2LPostGLLM10ft5x8 <tbody> </tbody> GLLM 5-1/8 x 7-1/2 @ 10f <tbody> </tbody> 0 3LPostGLLM10ft3x6 GLLM 3-1/8 x 6 @ 10ft 0 3LPostGLLM10ft5x8 <tbody> </tbody> GLLM 5-1/8 x 7-1/2 @ 10f <tbody> </tbody> 0 4LPostGLLM10ft3x6 GLLM 3-1/8 x 6 @ 10ft 4 4LPostGLLM10ft5x8 <tbody> </tbody> GLLM 5-1/8 x 7-1/2 @ 10f <tbody> </tbody> 7 <tbody> </tbody>

<tbody>
</tbody>

Thanks again for any help.

 

[sandy666]

it looks like

Bid Code​	Breakdown Code​	Quantity​	Column1
1LPostGLLM10ft3x6	GLLM 3-1/8 x 6 @ 10ft	#NAME?​	=ETkoBidQty("1LPostGLLM10ft3x6")
1LPostGLLM12ft3x6	GLLM 3-1/8 x 6 @ 12ft	#NAME?​	=ETkoBidQty("1LPostGLLM12ft3x6")
1LPostGLLM4ft3x6	GLLM 3-1/8 x 6 @ 4ft	#NAME?​	=ETkoBidQty("1LPostGLLM4ft3x6")
1LPostGLLM6ft3x6	GLLM 3-1/8 x 6 @ 6ft	#NAME?​	=ETkoBidQty("1LPostGLLM6ft3x6")

 

[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)