Countif function

[staffer]

I have a spreadsheet that tracks test data I am using the countif fuction but I now need to figure how many males passed and how many females passed and this information is in two different columns.When I write countif()+Countif() it adds the two and I want the number of males that passedno both combined.

 

[Aladin Akyurek]

On 2002-03-14 16:07, staffer wrote:
I have a spreadsheet that tracks test data I am using the countif fuction but I now need to figure how many males passed and how many females passed and this information is in two different columns.When I write countif()+Countif() it adds the two and I want the number of males that passedno both combined.

Care to post 5 rows of data along with the exact ranges where your data are?

 

[Dave Patton]

consider

=SUMPRODUCT((C49:C52="Male")*(E49:E52="Passed"))

-revise the 2 ranges to reflect your data
- assumes word "Male" is in Column C
- assumes word "Passed" is in ColumnE