I have a function that is =SUM(A32:A113) in cell K194, simple right? Well not
so much, it should be totalling up 67 and is showing 48, if I try to change
the formula, the formula is what shows in cell K194...what's going wrong? I
have other formulas giving me the same problems in the worksheet.

Thanks

Sounds like you're in manual calculation mode. Press shift+F9. See if the
result changes. If so, put Excel in Automatic mode.

"streaker6" wrote in message
...
I have a function that is =SUM(A32:A113) in cell K194, simple right? Well
not
so much, it should be totalling up 67 and is showing 48, if I try to
change
the formula, the formula is what shows in cell K194...what's going wrong?
I
have other formulas giving me the same problems in the worksheet.

Thanks

Nope, not in manual mode. I have checked that and I also tried to have it add
manually, still doesn't work.

"Tyro" wrote:

Sounds like you're in manual calculation mode. Press shift+F9. See if the
result changes. If so, put Excel in Automatic mode.

"streaker6" wrote in message
...
I have a function that is =SUM(A32:A113) in cell K194, simple right? Well
not
so much, it should be totalling up 67 and is showing 48, if I try to
change
the formula, the formula is what shows in cell K194...what's going wrong?
I
have other formulas giving me the same problems in the worksheet.

Thanks

On Thu, 3 Jan 2008 17:58:00 -0800, streaker6
wrote:

I have a function that is =SUM(A32:A113) in cell K194, simple right? Well not
so much, it should be totalling up 67 and is showing 48, if I try to change
the formula, the formula is what shows in cell K194...what's going wrong? I
have other formulas giving me the same problems in the worksheet.

Thanks

Most likely there is a problem with your data. What you describe can occur if
some of your values are really text that look like numbers. SUM will ignore
text.

Changing the format will not change the nature of the original entry, either,
so far as whether or not it is text.

You can verify this, I think, by entering this formula:

=SUMPRODUCT(--A32:A113)

If you get the correct answer, then either you entered constants when the cells
were formatted as Text; or you have formulas which are returning numeric values
as text.

If you get an error of #VALUE!, then possibly you copied some of the data from
a web page, and there are trailing <nbsp's that effectively make the entry
Text.

Post back with the test results.
--ron

On Jan 3, 5:58*pm, streaker6
wrote:
I have a function that is =SUM(A32:A113) in cell K194,
simple right? Well not so much, it should be totalling up 67
and is showing 48, if I try to change the formula, the formula
is what shows in cell K194.

What does that mean: "If I try to change the formula [what formula:
the one in K194?], the formula is what shows in cell K194"? Well,
duh! I am sure you mean something very different and useful; but what
you wrote is meaningless to me. Can you clarify? Perhaps give an
example.


what's going wrong?

I suspect that some/many/most of the cells in A32:A113 are actually
text, not numeric. In that case, SUM considers their value to be
zero. For example, if you have the formula =if(something,"1","2") in
a cell in column A, it might look like 1 or 2, but it is actually
text. Or you might have entered numbers into cells that were
formatted as Text.

Select the cell with the formula (K194?), and in the Formula Box of
the Formula Bar (fx), highlight the range A32:A113 and press F9.
Verify that they are all the numbers that you expect and no text.
Caveat: Press Esc afterwards to undo the effect of F9. If you
inadvertently press Enter, you will have changed the formula. Of
course, you can simply undo the change by pressing ctrl+z.

If that does not work, try a divide-and-conquer approach to isolating
the source of the problem. For example, change the range to A32:A72
(about half) and see if the sum is correct. If so, try the range
A73:A113; if should be wrong. Whichever is wrong, try dividing the
range in half again, and check the sum of each half.

Whatever you do, get out of the mindset that the "SUM function [is]
working improperly". SUM works just fine. Find your mistake.

Select the range A32:A113. Look on the Excel status bar. What does Excel's
autocalculate say the result is?

"streaker6" wrote in message
...
I have a function that is =SUM(A32:A113) in cell K194, simple right? Well
not
so much, it should be totalling up 67 and is showing 48, if I try to
change
the formula, the formula is what shows in cell K194...what's going wrong?
I
have other formulas giving me the same problems in the worksheet.

Thanks