See http://xldynamic.com/source/xld.SUMPRODUCT.html

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Marge" wrote in message
...
I used this formula after tweaking it in another application and it also
worked "perfectly" for me! Thank YOU!
Could you explain the necessity for the use of the hyphens...I'm not sure
why I use those to make this work?

"T. Valko" wrote:

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