Try the below in a fresh workbook. Your data starts from Row1 with no
headers...and runs upto row5 and in cell C1 place the formula

Col A Col B Col C
Woman 40 =SUMPRODUCT(--(A1:A100="Woman"),--(B1:B100=40))
Woman 40
Man 10
Woman 10
Man 10


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


"Tony_student" wrote:

Something was wrong.
Can I send you by email?
Thanks.


"Jacob Skaria" wrote:

With gender type in ColA and age in Col B try the below

=SUMPRODUCT(--(A1:A100="Woman"),--(B1:B100=40))

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


"Tony_student" wrote:

Let's say one colomn is a list of different gender types (man, woman, man,
woman and so on) and another colomn a a list og ages (25, 35, 40, 35 and so
on). What formula should I use to define how many woman of age 40? Thanks