Ok, I get it thanks. Now what I want to do is add all the values in the range
i.e. if there was a number of 150 then 50 would be counted in the range of
100 to 200.

Does that make sense?

"Bernie Deitrick" wrote:

Jules,

=SUMIF(Rangewithnumbers,"100")-SUMIF(Rangewithnumbers,"200")
=COUNTIF(Rangewithnumbers,"100")-COUNTIF(Rangewithnumbers,"200")

Though you may want:

=SUMIF(Rangewithnumbers,"=100")-SUMIF(Rangewithnumbers,"200")
=SUMIF(Rangewithnumbers,"100")-SUMIF(Rangewithnumbers,"=200")
=SUMIF(Rangewithnumbers,"=100")-SUMIF(Rangewithnumbers,"=200")

boundaries issues....

HTH,
Bernie
MS Excel MVP


"JulesHR" wrote in message
...
how do i doa formula that will count or sum a bunch of numbers that are
between a particular range. i.e. 100 but < 200 ?