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.

I would like to put the average value at the end of the list.
Perhaps with a "Average" label at the end of "Status", which would lie next to the average values?
I put a question mark, because i am not sure if such a thing is possible...