Excel Sorting Issue

[null null]

Hi 

I have a column of numerical data that I want to sort from the Largest to the Smallest, however, I do not have the option of sorting from Largest to Smallest, instead, it only has the option of sorting A to Z, or Z to A.

This an abstract of my data, I am trying to sort the "Total" column.

Then I tried to custom sort, and they did not have the sort "Largest to Smallest" option as well. Hence, I went to manually enter a new list and typed "Largest to Smallest" then click sort. But my data instead sort from the Smallest to Largest... 

How can I solve this?

[#2]

I suspect your numbers are not considered to be numbers but are seen as text.
Assuming these are NOT formulas:
Insert a blank workbook (control+n key), enter a 1 in a cell and hit control+c
Now go to your other workbook, select the "numbers" and hit control+alt+v to open the paste special dialog. Choose "Values" and "Multiply" and press OK.

[#3]

Hi Jan Karel, thank you for your reply.

However, these are formulas...  and the formula is as such: =IF(C4<>"",SUM(E4:M4),"")

[#4]

In that case they should add up. Is calc set to automatic?