Solved: Using IF command SUM copy paste special

[Tenspeed39355]

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

[GTO]

...The sum command will not work because the error message is stating that the 1 or 0 is a text and not a number...

Greetings Max,

Presuming you mean the worksheet function SUM, I don't get an error per se, but the results of the SUM are zero.

I am afraid you lost me a bit when referring to pastespecial, but what would not work with =IF(B3>A3,1,0) ?

Mark

[fb7894]

Get rid of the quotations in your formula.

=IF(B3>A3,"1","0")

should be

=IF(B3>A3,1,0)

[Tenspeed39355]

Mark By removing the quotations took care of my problem. Thank you
for your time with the problem. I will rate the thread *****
Max

[GTO]

Hey Max,

Very happy to help,

Mark