I am trying to use a range of numbers to determeine a condition for adding
amounts in a column. I am using the following,

=SUM(IF($F$16:$F$61="100",IF($K$16:$K$61=1,$I$16:$ I$61,0),0))

but were "100 is I would like to be able to include any number from 100 to 199

is this possible, and if so, how can I do this?

One way:

=SUMPRODUCT(--($F$16:$F$61=100),--($F$16:$F$61<=199),
--($K$16:$K$61=1), $I$16:$I$61)

See http://www.mcgimpsey.com/excel/doubleneg.html for an explanation of
the "--"


In article ,
cliff3466 wrote:

I am trying to use a range of numbers to determeine a condition for adding
amounts in a column. I am using the following,

=SUM(IF($F$16:$F$61="100",IF($K$16:$K$61=1,$I$16:$ I$61,0),0))

but were "100 is I would like to be able to include any number from 100 to 199

is this possible, and if so, how can I do this?