Whoops! I think Bob got it right.....mine incorrectly includes items =199

***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Try something like this:

=SUMIF($F:$F,"=100",$G:$G)-SUMIF($F:$F,"199",$G:$G)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

I have this formula that works for a partial need.
=SUMIF($F:$F,110,$G:$G)

How can I modify the above formula to provide the above result only if the A
column has #'s =100 and < 199 ? The A column has #'s from 0 thru <400.
I need other ranges also, but if I get the above, I could figure out the
others.

Thanks much,

Steve