Countif with Index on a Pivot Table

[emorymule]

Pulling off Pivot Table
example:
[TABLE="width: 340"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Part Number[/TD]
[TD]Company 1[/TD]
[TD]Company2[/TD]
[/TR]
[TR]
[TD]part 1[/TD]
[TD]60[/TD]
[TD]61[/TD]
[/TR]
[TR]
[TD]part 2[/TD]
[TD]50[/TD]
[TD]52[/TD]
[/TR]
[TR]
[TD]part 3[/TD]
[TD]40[/TD]
[TD]60[/TD]
[/TR]
</tbody>[/TABLE]


Looking to do a countif on the entire row based on the part number with greater than or equal to 50.

So I would look up "Part 1" and get a total of 2 because both are greater than 50.

Need help on that index/match/countif formula... nothing is working

 

[RasGhul]

It may be easier to do the Countifs from your raw data set instead of pivot, can you post some sample data?