Excel 2007 : sum a column containing formulas

[gsdanger]

Good Evening everyone. This is my first time on this forum.
I need some of your expert advice with this problem I have encountered with Excel 2007.

i have 4 columns that contain numbers. no big deal here...
The cells in these columns have formulas ( eg: =if(c4<>"",left(r4,2). The source of this number looked like this: 28 (5.6.3), I just want the first number).

So in my columns, I have formulas that show the result of this extraction.

I now want to sum the results of these formulas. 28 etc....

how can i do this, as when I use the common =sum(column range), all I get is 0.

Would appreciate any assistance from anyone. Kind Regards..

By the way, i am a novice at excell 2007, so any answers will probably have to be beaten into me.

Again, Kind Regards.

gsdanger

[NBVC]

Change the original formula to:

=if(c4<>"",left(r4,2)+0....

the +0 coerces your result to true numbers..as LEFT() results are always text... and so you cannot sum...

[gsdanger]

Change the original formula to:

=if(c4<>"",left(r4,2)+0....

the +0 coerces your result to true numbers..as LEFT() results are always text... and so you cannot sum...

Good Day NBVC.

Hooray!!...Success.now I can sleep better.
NBVC, thank you very much for your prompt and accurate reply. Sometimes it's better to ask the knowledgeable, rather than attempting to find the answer in a reference book (it's usually not in there). Once again, thank you for this fix. it worked beautifully.

Kind Regards..

gsdanger