Use SUMPRODUCT()
=SUMPRODUCT((A2:A6="m")*(B2:B610)*(B2:B6<=20))

If this post helps click Yes
---------------
Jacob Skaria


"an" wrote:

Hi!

I have next:

Col A Col B

m 10
f 23
f 54
m 20

I would like to Count:

m 10 to <=20
m 20 to <=30
m 30 to <=40
...
f 10 to =20
f 20 to =30
f 30 to =40
...

Thanks in advance
an