Try this:

=SUMPRODUCT(--(A1:A10=100),--(A1:A10<199),--(F1:F10=110),G1:G10)

Note: you can't use entire columns as range references - A:A

Biff

"Steve" wrote in message
...
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