Again, you can use your original formula and just change the range that you
wish to total:

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

--

HTH,

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


"jeremy via OfficeKB.com" wrote in message
...
Sorry, I forgot to specify that I want to sum a second column if the first
meets the criteria range...

Eg. =SUMIF($BE$9:$BE$272, 0=<X<10, ($BF$9:$BF$272))

Of course, 0=<X<10 doesn't work.....

Thanks....


JE McGimpsey wrote:
One way:

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

another:

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

a third

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

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