| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| autosum | Excel Discussion (Misc queries) | |||
| Why does a column add incorrectly when usng autosum? | Excel Worksheet Functions | |||
| Macro code to autosum a dynamic length column | Excel Discussion (Misc queries) | |||
| How do I Autosum a running column total in excel? | Excel Worksheet Functions | |||
| autosum ?? | Excel Worksheet Functions | |||
Hybrid Mode
