Barb,

It sounds like a rounding issue. What you see displayed may not be the
exact value of the cell. Try modifying your formulas to round the value of
the cell, not just the display.

Tim C

"Barb Reinhardt" wrote in message
...
I want to sum the values in cells E2:P110 based on the values column D.
The
values in D are formulas resulting in something that appears to match D112
in
some cases. I'm using the following equation:

=SUMIF(D2:D110,D112,E2:P110)

My problem is that D2 :D10 have a formula in it and it's not matching.
If
I enter the result of the formula, all is good. How should I deal with
this?

Thanks in advance,
Barb Reinhardt