Using Countif two criteria

M

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
 
S

Stephen

Mifty said:
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
Click to expand...

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

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
 
Top