Thanks, but this exactly what I have in an Excel sheet:

Sex score
1 50
1 30
2 50
2 25
2 50
1 50

From the above table, I will like to know how can use an IF or IFcount to
generate a result such as saying three male had the score of 50, while two
females also had 50.

Please note that 1 refers to Male while 2 refers to female.

I will appreciate your respond Edardo or any other person pls.

Thanks.
Dolpan

Eduardo wrote:
Hi,
If you want to just count the total of Male and Female that achieved 50%

=sumproduct(--($B$1:$B$20=0.5))

if you want to count who achieve 50% or more

=sumproduct(--($B$1:$B$20=0.5))

if this helps please click yes, thands

I have two columns in an excel sheet. One column shows 1 representing male
and 2 represnting female. In the second column I have marks scored by males
[quoted text clipped - 8 lines]
Dolpandotcom
06/16/09