[Anida]

Despite formula I use (for example the most simple SUM) it always shows me
zero result even it should show a lot more. Values in other cells (cells that
I sum) are in number format. Why this happens??

[ExcelBanter AI]

I'm sorry to hear that you're experiencing this issue with your Excel formulas. There could be a few reasons why you're getting a zero result, even though you're using the SUM formula correctly.

Here are a few things you can check:

1. Make sure that the cells you're trying to sum are actually numbers. Sometimes, Excel can interpret numbers as text, which can cause issues with formulas. To check this, select the cells you're trying to sum and look at the "Number Format" dropdown in the "Home" tab. If it says "Text", you'll need to change the format to "Number".
2. Check that the cells you're trying to sum are not empty. If there are any blank cells in the range you're trying to sum, Excel will return a zero result.
3. Make sure that the cells you're trying to sum are not hidden. If any of the cells in the range you're trying to sum are hidden, Excel will not include them in the calculation.
4. Check that the formula is actually referencing the correct cells. Sometimes, when you copy and paste a formula, Excel can accidentally change the cell references. Double-check that the formula is referencing the correct cells.
5. Finally, make sure that there are no circular references in your workbook. Circular references occur when a formula refers to itself, which can cause Excel to return incorrect results.

I hope these tips help you resolve the issue with your formulas. Let me know if you have any other questions or if there's anything else I can help you with!

[David Biddulph[_2_]]

It doesn't matter whether the cells are FORMATTED to DISPLAY as number;
what matters is whether the CONTENTS are numbers. My guess is that they are
text that might look like a number. If one of your numbers is in A2, what
do the formulae =ISTEXT(A2) and =ISNUMBER(A2) show?
--
David Biddulph


"Anida" wrote in message
...
Despite formula I use (for example the most simple SUM) it always shows me
zero result even it should show a lot more. Values in other cells (cells
that
I sum) are in number format. Why this happens??

[Max]

This quick fix might suffice for you
Instead of using: =SUM(A2:A5)
use this, array-enter it, ie press CTRL+SHIFT+ENTER to confirm the formula:
=SUM(A2:A5+0)
The "+0" will coerce all text numbers (if any) within the source range
(A2:A5) to real numbers w/o impacting their intrinsic values, and return the
desired results. Happy? hit the YES below
--
Max
Singapore
---
"Anida" wrote:
Despite formula I use (for example the most simple SUM) it always shows me
zero result even it should show a lot more. Values in other cells (cells that
I sum) are in number format. Why this happens??

[Anida]

When I put =isnumber(a2) it shows me true, and for =istext false. What next?

"David Biddulph" wrote:

It doesn't matter whether the cells are FORMATTED to DISPLAY as number;
what matters is whether the CONTENTS are numbers. My guess is that they are
text that might look like a number. If one of your numbers is in A2, what
do the formulae =ISTEXT(A2) and =ISNUMBER(A2) show?
--
David Biddulph


"Anida" wrote in message
...
Despite formula I use (for example the most simple SUM) it always shows me
zero result even it should show a lot more. Values in other cells (cells
that
I sum) are in number format. Why this happens??


.

[Dave Peterson]

Make sure that calculation is set to automatic.

In xl2003 menus:
tools|options|calculation tab

And your range to sum does include A2, right?

Anida wrote:

When I put =isnumber(a2) it shows me true, and for =istext false. What next?

"David Biddulph" wrote:

It doesn't matter whether the cells are FORMATTED to DISPLAY as number;
what matters is whether the CONTENTS are numbers. My guess is that they are
text that might look like a number. If one of your numbers is in A2, what
do the formulae =ISTEXT(A2) and =ISNUMBER(A2) show?
--
David Biddulph


"Anida" wrote in message
...
Despite formula I use (for example the most simple SUM) it always shows me
zero result even it should show a lot more. Values in other cells (cells
that
I sum) are in number format. Why this happens??


.


--

Dave Peterson

[Dave Peterson]

And any chance that the sum is 0? Maybe you have positive, negative and zero
values in the range?

And one more thing to check.

Type these two formulas in separate cells:
=count(A1:a10)
=counta(a1:a10)

(change A1:A10 to the range you're summing.)

=count() will count the numbers in the range.
=counta() will count numbers, strings, even formulas that evaluate to "" in the
range.

Anida wrote:

When I put =isnumber(a2) it shows me true, and for =istext false. What next?

"David Biddulph" wrote:

It doesn't matter whether the cells are FORMATTED to DISPLAY as number;
what matters is whether the CONTENTS are numbers. My guess is that they are
text that might look like a number. If one of your numbers is in A2, what
do the formulae =ISTEXT(A2) and =ISNUMBER(A2) show?
--
David Biddulph


"Anida" wrote in message
...
Despite formula I use (for example the most simple SUM) it always shows me
zero result even it should show a lot more. Values in other cells (cells
that
I sum) are in number format. Why this happens??


.


--

Dave Peterson