Posted to microsoft.public.excel.misc
|
|
2 conditions
Exactly, JS!
Thnaks
an
"Jacob Skaria" wrote:
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
|