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?