Count Letters

Hi

I was hoping someone could help.

Is there a way I can count the total number of letters in the + and - columns and populate K3 to K9 with the net totals ?

So it looks at how may "+ A's there are in the + column, how many "-A's there are in the negative column and gives me the net number as a + or - in K

Secondly is there a way to have these lined by and change dynamically in in columns M as the values in K change. Biggest number at top

Thanks in advance

Hi

CountIf worked great thank you.

Are you able to help on the last part?

So there are 7 products A,C,D,I,M,S,X

I want to be positive on 3 and negative on 3, with no position on 1

So if A is in the top 3 in the NET column (M) Q3 (Position) would = 3 (p3)

IF A is in the bottom 3 in the NET column (M) Q3 (Position) would = -3 (P3*-1)

The letter in the middle (not in top 3 or bottom 3 by count is always 0

AND IF

There are not any clear winners, such as positions, 3,4,5 are the same (M) it only assigns values in Q to the top 2 and bottom 2

Thank you

if 3 4 5 are the same it only does 1, 2, 6,7