# Sum Text

#### jkktx81

##### Board Regular
I have 2 questions; I have done these same things several times before but can't get to work this time.

1: Trying to have formula that will show what text is another cell and it keep showing up as a 0 instread of the text that is in that cell.

2: Trying to sum data from another workbook. I thought before I have been able to click the cell in destination workbook, then switch to source WB and click it, then when when I switch back to destination WB it would show that formula, but not happening.

Any help appreciated...

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Q1

Excel 2010
ABC
1Numbers as textNumberNumber
2222222222222222
3FALSETRUETRUE
Sheet1
Cell Formulas
RangeFormula
B2=A2+0
B3=ISNUMBER(B2)
C2=VALUE(A2)
C3=ISNUMBER(C2)
A3=ISNUMBER(A2)

Q2:
Can you give more details.
What's happening when you are switching back to destination workbook?
Are you opening the another workbook from withing the first one?
(File-->Open...

Thanks Robert on the ISNUMBER help.

I will work on the other question later today and reply back after trying to get that to work.

But yes I was working with 2 different workbooks and both open. Trting to pull data from cells of the other workbook.

I am trying to pull the data from the other open workbook.

It does fine until I get to where there is text in the cell and it will not show the text only displays 0.

I have tried using conditional formatting and entering =ISNUMBER(C8).

Here is the formula result that would not work.
=SUM('[Load Track 2012 Master rev 05-2012.xls]APR'!\$X\$8)

CF does not change to text to Value.
As I see you trying to SUM one cell only?

You can try like this:
Excel 2010<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px"><colgroup><col style="background-color: #DAE7F5" width="25px"><col><col></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;">8</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">
</td><td style="text-align: right;;">8</td></tr></tbody></table>
Sheet3

But this is quite akward way of using SUM for one cell only
You can change that to

Excel 2010<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px"><colgroup><col style="background-color: #DAE7F5" width="25px"><col><col></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;">8</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">
</td><td style="text-align: right;;">8</td></tr></tbody></table>
Sheet3

Which give the same result

Replies
4
Views
221
Replies
1
Views
110
Replies
2
Views
107
Replies
6
Views
82
Replies
0
Views
363

1,203,127
Messages
6,053,663
Members
444,676
Latest member
locapoca

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back