autosum on a column

[volunteer]

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!

 

[Kevin B]

Change your formula to the following:

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

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

 

[Andrea Jones]

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

 

[muddan madhu]

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

 

[volunteer]

Thank you!

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