Using Countif two criteria

[Mifty]

Hi Everyone,

I would like to be able to count the number of females with a score in C.
so using Countif how do I say countif B = F and C equals a number?

I'd be grateful for any ideas how to do this.
Could I use Sumproduct as an alternative to countif?

Thanking you in advance

 

[Stephen]

Hi Everyone,

I would like to be able to count the number of females with a score in C.
so using Countif how do I say countif B = F and C equals a number?

I'd be grateful for any ideas how to do this.
Could I use Sumproduct as an alternative to countif?

Thanking you in advance

Try something like
=SUMPRODUCT((B1:B100="F")*(C1:C100>0))

 

[Pete_UK]

You can use COUNTIF if you only have one condition. In this case try:

=SUMPRODUCT((B1:B100="F")*(ISNUMBER(C1:C100))

Hope this helps.

Pete

 

[Mike H]

Maybe

=SUMPRODUCT((B1:B20="F")*(ISNUMBER(C1:C20)))

Mike

 

[Mifty]

Thank you to Stephen, Pete and Mike.

Sumproduct seems quite a useful function

Cheers

 

[Pete_UK]

Thanks for feeding back - see here for further details on the use of
SUMPRODUCT:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Hope this helps.

Pete