=SUMPRODUCT(--(range8),--(range<=11.99),--(sum_range))

--
Regards,
Dave


"DMM" wrote:

Trying to use "AND" function in criteria portion of "COUNTIF" function. More
specifically want numbers to sum if the number in the "range" falls between
two numbers e.g. AND(8,<=11.99). In this example all numbers in the "range"
that fall between 8.01 and 11.99, their corresponding number in the
"sum_range" should be summed. I can't seem to make this work. Any
suggestions?

Thanks