Thread: SUMIF Question
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_4_] Minitman[_4_] is offline
external usenet poster
 
Posts: 273
Default 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