Countif based on condition in another cell.

[Chuck712]

I have a spreadsheet that I need to do some analysis on. I am trying to count a range of cells if they have a value higher than a standard, but need to only count them if the value in another cell is met. Here is what I have (short version)

Waist Gender
11.0 F
12.0 M
06.0 M
10.5 F

I want to count the cell if the waist is greater than 10, but the Gender is F.

I am sure that this is simple, but I am having trouble finding anything on it.

 

[bluedragon2]

=sumproduct((a1:a4>=10)*(b1:b4="F"))

For explanation, see FAQ68-4725

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Chuck712]

Thanks. I looked all over but couldn't find it. This is just what I needed.