I guess I didn't quite explain this completly. There's various #'s in the F
column, and I want the formula to work with any 110 in that column, which it
currently does. That's where the:$F:$F,110 is from. In addition, I have
various other #'s in the A column, and that where the 100 and <199 come from.
Basically, if A is = 100 and <199 , and F has a 110, sum the corresponding
#'s in the G colum that match the A & F criterea.

Thanks,

Steve

"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