Hi

I'm having exactly the same problem, although with a slightly more
complicated formula. The formula is this: SUMIF('July
06'!$K$3:$K$36,'Report'!$A$24,'July 06'!$R$3:$R$36), the idea being to get a
sum of column R if the name in A24 appears in column K. The only result this
formula is displaying is 0, but in the arguments box it gives the correct
answer of 43. adding, subtracting, dividing etc. anything to this cell gives
a result of 0, eg formula + 10 will show 0, dividing something by this
result, instead of showing div/0 will show 0. I've tried every format
available, copied it to different cells etc, but will only display the 0
result. Any ideas other than what's been mentioned?

Thanks

"Sloth" wrote:

You might get better responses if you post the following

1. Values of Referenced Cells
2. Formula you are using
3. Actual Result
4. Desired Result

Example:
A1: 34
B1: 12
C1: =SUM(A1-B1)
outputs 6, but is supposed to output 22.

In which case I would tell you to check the formats of each cell, and ask
you why you were using the SUM function.

"Excel User" wrote:

I have a simple formula subtracting one cell from another using =SUM(XX,
-XX). When I click on fx and bring up the function arguments box, the
formula result is displayed correctly in that box. However, the cell
containing the formula will only display a zero. I have tried reformatting
the cells to no avail. I have also tried getting a result using =XX-XX and
that does not work either.