A B C D
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
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