Anytime you do calculations in Excel that involve decimals you start to make it
hard if you need things to be exactly equal. Comes down to the problem of
expressing fractional numbers in binary format, and so it's usually easiest to
just round the data off using ROUND. Your data may well have been only
0.0000000000001 off due to the problem, but that's enough under certain
conditions to get a FALSE return with an x = x type scenario.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Minitman" wrote in message
...
Hey Ken,

There should not have been but II guess there was.

Your modification works like a charm

Thank you.

-Minitman

On Sat, 6 Nov 2004 20:13:01 -0000, "Ken Wright"
wrote:

Could it be a rounding issue - are the values the results of formulas - What
happens if you try

=ROUND(SUMIF($X$2:$X$250,$X2,$E$2:$E$250)-SUMIF($X$2:$X$250,$X2,$F$2:$F$250),2)0

or

=(ROUND(SUMIF($X$2:$X$250,$X2,$E$2:$E$250),2)-ROUND(SUMIF($X$2:$X$250,$X2,$F$2:$F$250),2))0



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004