View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default 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!