I can’t for the life of me figure this out; neither on my own nor through hours of googling. Here’s the deal:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
> </o
>
I have a column of numbers I want to sum (or sumif.) These numbers are the result of several other functions. I THINK the root of the problem is that the numbers are pulled from the results of a CONCATENATE function (I used this to nest 17 IF functions.) I think that’s the root of the problem because I can’t seem to change the format to a number. (I changed it in the ‘format cells’ window, but none of the number styles do anything which would indicate a successful format change.) I’ve also used the LEFT and LEN functions to try to eliminate any non-number characters that, from what I’ve read, can be ‘non-printable?’ and can result from concatenating cells.
Here’s the part that’s really confusing though – If I manually write in an equation to sum two values resulting from the concatenate function, for example, A1+A2, then it gives me the sum, but, again, the formula =SUM(A1:A2) just gives me 0. <o
></o
>
<o
> </o
>
I hope this description of my problem makes sense. It barely does to me. Any help would be great. Thanks.<o
></o
>




<o


I have a column of numbers I want to sum (or sumif.) These numbers are the result of several other functions. I THINK the root of the problem is that the numbers are pulled from the results of a CONCATENATE function (I used this to nest 17 IF functions.) I think that’s the root of the problem because I can’t seem to change the format to a number. (I changed it in the ‘format cells’ window, but none of the number styles do anything which would indicate a successful format change.) I’ve also used the LEFT and LEN functions to try to eliminate any non-number characters that, from what I’ve read, can be ‘non-printable?’ and can result from concatenating cells.
Here’s the part that’s really confusing though – If I manually write in an equation to sum two values resulting from the concatenate function, for example, A1+A2, then it gives me the sum, but, again, the formula =SUM(A1:A2) just gives me 0. <o


<o


I hope this description of my problem makes sense. It barely does to me. Any help would be great. Thanks.<o

