sum command do not display the result eg:=sum(c5:c8)-total not

A

abbbalu

sum command do not display the result eg:=sum(c5:c8)-total not display the
result in the cell

even when sigma is clicked the same
 
D

Dave Peterson

What is displayed instead?

If you see the formula, then format the cell as General (or anything but text)
and reenter that formula.

If you see the wrong answer, then maybe you have calculation set to manual.
Tools|Option|calculation tab
is how you'd change it in xl2003 menus.

If that's not it, then maybe your values in those cells (C5:C8) aren't really
numbers. Reformat that range as General (not text) and reenter the values.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The sum of the same function that is used for a range of cells 2
Sigma sums 2
Time Sum in Excel 1
sum totals in excel 4
A useful AVERAGE calculation without using the built-in AVERAGE function 3
Summing a range of cells based on criteria in another range 2
@Sum Conditional Values within a Macro 1
How to generate a text file from Excel using a macro or script? 0

Top