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