thanks--that was brillant...

RagDyeR wrote:
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")

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