The Sumproduct formula that you quoted in your earlier post will do the same
job for this by just adding an additional argument:

=SUMPRODUCT(($W$9:$W$272=0)*($W$9:$W$272<10)*$W$9 :$W$272)

OR

=SUMIF($W$9:$W$272,"0")-SUMIF($W$9:$W$272,"=10")

--

HTH,

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

"jeremy via OfficeKB.com" wrote in message
...
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.


--
Message posted via http://www.officekb.com