Generate Percentage summary table for all test point numbers

Hi,

I am trying to generate a summary table with percentages (example of what I want on the right) but I want to do this across the ranges for all test points. So for test point 2, I want excel to calculate the percentage of P, W and F (Pass, Warning, Fail) for range A26:A55 and then so on for all the other test points. Is there a way to automate this using a pivot table or macro?

Once this is done for all test points, I want to filter for test points that had a high failure rate (>50% F).

Thanks.