Pulling off Pivot Table
example:
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
<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
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