SUMIF Question
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
|