This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
in the past I was able to add numbers with no problem using the formula " =sum(s24,p27) " it would add the numbers in both cells and give the answer, the total. now all that happens is it shows the function as I typed it. I went to the help menu and followed the instructions, =sun(s26:s36) to get a total of the ten numbers in the " S colum" rows 26 thru 36, but again all I can get is exactly what I typed, the formula. Can anyone help me?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Your cell could be formatted as text. Right click the cell, choose Format Cells, and click the number tab. If Text is highlighted at left, change it to somthing else like General or Number. Then click OK and re-enter the formula.
Ken Puls, CMA, MS MVP (Excel)
Answer accepted by question author
in the past I was able to add numbers with no problem using the formula " =sum(s24,p27) " it would add the numbers in both cells and give the answer, the total. now all that happens is it shows the function as I typed it. I went to the help menu and followed the instructions, =sun(s26:s36) to get a total of the ten numbers in the " S colum" rows 26 thru 36, but again all I can get is exactly what I typed, the formula. Can anyone help me?
This usually means the cell is formatted as TEXT.
Change the cell format to General then re-enter the formula (in that sequence).
--
Biff
Microsoft Excel MVP
You may be in 'Show Function Mode'. Press the toggle switch keyboard CTRL+` (e.g. left 'smart' quote or lower case tillde, just above the tab) to switch Excel's display between the two.