Formula

I posted earlier and the cols ran together, if it does it again I can send anyone a sample in EXCEL.. Plese e-mail me at res@lvcm.com

I HAVE CHANGED THE COLUMNS BUT MAYBE WORDED IT WRONG. The P and B or x's can be either or . As you see, the D column is the correct Count.. The P's (Col b and Col e) =2 and the B's (Col c and f =1) If necessary, I could change the P in Col B and B in Col C to an X.....

P in B col = 2
X in E Col = 2
B in C Col = 1
X in F Col = 1

B C D E F
----------------------------------
P B Count P B
----------------------------------
B 2 x
B 3 x
P 3 x
P 2 x
B 2 x
P 3 x
B 3 x
P 2 x
B 3 x
B 2 x
P 3 x
P 2 x
B 2 x
P 3 x
B 2 x
P 3 x