Filter, Remove then average left overs

I have been trying to find a way to Filter two Columns.
First by filtering the "Part number" so that they are grouped, which I believe I have done.
From there, filter the "Status" by removing anything with an "F", then deleting that row.
Next remove anything else that does not contain "Pass", "P_TC" and "PTC".
All that should be left when filtering the "Status" is "Pass", "P_TC" and "PTC".
And lastly, the averaging of "Zero" and "Span" values for each "Part Number".

Maybe I am doing it in the wrong order.

Any help in the right direction will be valued.
Thank you in advance.