Countif with Index on a Pivot Table

[emorymule]

Pulling off Pivot Table
example:

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

Part Number	Company 1	Company2
part 1	60	61
part 2	50	52
part 3	40	60

<tbody>
</tbody>

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?