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

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

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

How about explaining how the suggestions didn't work.

And sharing the version of the formula you tried. You may have made a mistake
in entering it.

And what version of excel are you using?

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

--

Dave Peterson

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

Everything is fine now! I changed "," sign to ";" and everything works.

Here is another problem:
Define the most popular hair colorof these woman of age 40, provide the
exact number of woman with this (most popular color)
Thanks!

"Dave Peterson" wrote:

How about explaining how the suggestions didn't work.

And sharing the version of the formula you tried. You may have made a mistake
in entering it.

And what version of excel are you using?

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

--

Dave Peterson

Everything is fine now! I changed "," sign to ";" and everything works.

Here is another problem:
Define the most popular hair colorof these woman of age 40, provide the
exact number of woman with this (most popular color)
Thanks!


"Jacob Skaria" wrote:

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