autosum on a column
 

I have a function in column C which refers to column B, the function puts
either a 0 or a1 into column C, but coulumn C will not autosum,, why? is it
not recognizing the result of 0 or 1 as a number? if not, how can I make it
do it? here is my function:
=IF(ISBLANK(B281),0,"1")
thanks in advance for any help!

autosum on a column
 

Change your formula to the following:

=IF(ISBLANK(B281),0,1)

The 1 in quotes was treated as a string and not a value.

--
Kevin Backmann


"volunteer" wrote:

I have a function in column C which refers to column B, the function puts
either a 0 or a1 into column C, but coulumn C will not autosum,, why? is it
not recognizing the result of 0 or 1 as a number? if not, how can I make it
do it? here is my function:
=IF(ISBLANK(B281),0,"1")
thanks in advance for any help!

autosum on a column
 

Don't put the 1 in inverted commas, Excel sees that as text and can't add it.
It should be

=IF(ISBLANK(B281),0,1)

Andrea Jones
www.stratatraining.co.uk
www.wrekinpublishing.com

"volunteer" wrote:

I have a function in column C which refers to column B, the function puts
either a 0 or a1 into column C, but coulumn C will not autosum,, why? is it
not recognizing the result of 0 or 1 as a number? if not, how can I make it
do it? here is my function:
=IF(ISBLANK(B281),0,"1")
thanks in advance for any help!

autosum on a column
 

remove the double quote used for the value 1 in your function.


On May 30, 5:43*pm, volunteer
wrote:
I have a function in column C which refers to column B, the function puts
either a 0 or a1 into column C, but coulumn C will not autosum,, why? is it
not recognizing the result of 0 or 1 as a number? if not, how can I make it
do it? *here is my function:
=IF(ISBLANK(B281),0,"1")
thanks in advance for any help!

autosum on a column
 

Thank you!

"Andrea Jones" wrote:

Don't put the 1 in inverted commas, Excel sees that as text and can't add it.
It should be

=IF(ISBLANK(B281),0,1)

Andrea Jones
www.stratatraining.co.uk
www.wrekinpublishing.com

"volunteer" wrote:

I have a function in column C which refers to column B, the function puts
either a 0 or a1 into column C, but coulumn C will not autosum,, why? is it
not recognizing the result of 0 or 1 as a number? if not, how can I make it
do it? here is my function:
=IF(ISBLANK(B281),0,"1")
thanks in advance for any help!