<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>