1 NALM 100% NOB 0%

2 NOB 100% NOB 100%

3 NOB 0% NALM 0%

I am looking to find all the (NOB) in this sheet and them take all the % for the (NOB) and avgrage them out

There is 4 NOB and 4 % 2 are 100% and 2 are 0% the avgrage 50% I was trying to use sumproduct but it will not work please help thank you