One way:

=SUMPRODUCT(--(rng=0),--(rng<10), rng)

another:

=COUNTIF(rng,"=0") - COUNTIF(rng, "=10")

a third

=COUNTIF(rng, "<10") - COUNTIF(rng, "<0")



In article ,
"jeremy via OfficeKB.com" wrote:

I'm still an excel newbie--I searched the archives but couldn't find the
answer...

How do I use sumif function when the criteria is a range (eg. =0 to <10 ).

Thanks.