One way:

=SUMPRODUCT(--(M3:M20>0.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:M20>0.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