Tenspeed39355
06-24-2009, 04:35 PM
Hi Here is the problem I have run into. I have in Column A a column of numbers. The same for Column B. In column C I am using the IF statement. =IF(B3>A3,"1","0"). If the number in column B is larger I get a
1, if the number in column B is less I get a 0. Here is when the problem comes in. At the bottom of the column I want the SUM. The sum command
will not work because the error message is stating that the 1 or 0 is a text and not a number. I can change the text to a number so the SUM command works by doing a copy paste special but then I loose the formula which I want to keep. My question is how do I keep the formula and get the SUM command to work. Thanks for any help with this one.
Max
1, if the number in column B is less I get a 0. Here is when the problem comes in. At the bottom of the column I want the SUM. The sum command
will not work because the error message is stating that the 1 or 0 is a text and not a number. I can change the text to a number so the SUM command works by doing a copy paste special but then I loose the formula which I want to keep. My question is how do I keep the formula and get the SUM command to work. Thanks for any help with this one.
Max