2 conditions

  • Thread starter Thread starter an
  • Start date Start date
A

an

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
 
Hi an,

if your data are for example in the range A1:B20, the following formula will
count all the m in column A with values >10 and <=20 in colum B:

=SUMPRODUCT(($A$1:$A$20="m")*($B$1:$B$20>10)*(B1:B20<=20))

you can easily adapt the formula for your other conditions.

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.


Thanks in advance for your feedback.


Ciao


Franz Verga from Italy (now in Berlin)
 
Use SUMPRODUCT()
=SUMPRODUCT((A2:A6="m")*(B2:B6>10)*(B2:B6<=20))

If this post helps click Yes
 
Back
Top