MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula


Posted by Brittany on July 25, 2001 1:04 AM

I would like to create a formula that did a simple addition...
B = 1
P = 2

If B is in column B2 and P is in column B8, I want a formual in B9 that interprets the b=1 in B2 and adds it to p=2 in b8 with the sum in B9...


Posted by Aladin Akyurek on July 25, 2001 2:02 AM

Brittany,

Apparently you're not after

=B2+B8

which is in B9, are you?

Aladin

===========

Posted by Lars on July 25, 2001 10:35 AM

Here you go

=sum(right(b2,1))+right(b8,1)

Posted by Brittany on July 26, 2001 2:15 AM

i HAVE CBHANGED 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
AS below If B in Col c
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

Posted by Aladin Akyurek on July 28, 2001 1:18 AM


See: 24777.html

============ i HAVE CBHANGED 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