Countif with Index on a Pivot Table

emorymule

New Member
Joined
Nov 5, 2019
Messages
1
Pulling off Pivot Table
example:

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
Part NumberCompany 1Company2
part 16061
part 25052
part 34060

<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 :(
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

RasGhul

Well-known Member
Joined
Jul 15, 2016
Messages
611
It may be easier to do the Countifs from your raw data set instead of pivot, can you post some sample data?
 

Watch MrExcel Video

Forum statistics

Threads
1,129,868
Messages
5,638,763
Members
417,051
Latest member
arthur_w

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top