SUM formula not counting positive numbers in column

[WGBarry]

Guys I seem to be having a serious problem with a work book. In column K I have a list of numbers if I highlight them all rather than just doing a SUM it does a SUM but only of the negative numbers and completely misses out ones which are positive?

New Microsoft Excel Worksheet (2).xlsx

[arthurbr]

The + numbers are numbers stored as text

You can re-type them or
Enter 1 in an empty cell and copy this value
Select col K ( all values is OK)
Right click - Paste special - Multiply
Now all numbers are real numbers and the sum should be OK

[mrice]

Try this syntax instead

=SUM(L2,K3)

Also some of your numbers are text rather than numbers. Suggest selecting each, hit F2 and then return to fix.

[zbor]

What are you using for delimiter? I see comma and I see point. You writted your numbers as text.

Also, there is no need to write: =SUM(L12+K13)

Write either =SUM(L12,K13) or just =L12+K13

[Pete_UK]

Put this formula in N2 (say):

=ISNUMBER(K2)

then copy down. You can see that the three positive numbers near the bottom of your list are not actually numbers - rather, they are text values that just look like numbers. To rectify this and to convert them all into numbers, put 1 in a blank cell somewhere. Select that cell and click <copy>. Move the cursor and highlight all the numbers from K2 to K17, then right-click and choose Paste Special, then click against Values and against Multiply, then click OK and press the <Esc> key.

Hope this helps.

Pete

[WGBarry]

Thank you guys, looks like I will have to get an office minion go go through the 190,000 or so cells then!

[arthurbr]

Thank you guys, looks like I will have to get an office minion go go through the 190,000 or so cells then!

Why should you do that?