I have never seen that, I just tested a dummy range where I rounded
and used SUMIF and I got the result I expected?

--


Regards,


Peo Sjoblom

"Mike H." wrote in message
...
It appears that in certain circumstances when I do a sumif that includes
fields that contain a rounding function that the rounded numbers are
omitted
from the sumif. Has anyone else experienced a similar situation and could
possibly shed light on this issue? Version 2003.