Thanks for this, I just now need one more tweak for a different section and I can put this spread sheet to bed

I need to tweak:

=SUMPRODUCT(('FFTA25%'!$U$2:$U$180="5a")*(ISNUMBER(SEARCH("C",'FFTA25%'!$AC$2:$AC$180))))

So that before it counts the C-,C or C+ grade in column AC, it still checks 5a is in U, but ALSO it checks PP is in column F.

Any help would be really appreciated.

Thanks