John,

Countif ?
Confusing the OP's 2 posts?<g
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"JE McGimpsey" wrote in message
...
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.