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
