One way:

=SUMPRODUCT(--(M3:M200.4),--(M3:M20<0.61))

=sumproduct() likes to work with numbers. The -- changes true/false to +1/0.

"Patty via OfficeKB.com" wrote:

I want to count the number of cells whose values fall between 0.40 and 0.61.
I did

=SUMPRODUCT((M3:M200.4)-(M3:M20<0.61))

but the result is not the same as when I manually count the number of cells
so the formula is clearly wrong.

how do I fix?

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

--

Dave Peterson