Countif (multiple conditions)

[gymwrecker]

I have the following formula:

=COUNTIF($F$2:$F$179,"F")

Is there a way to "countif" using two conditions, for example, this one contains all the "f" (females); how could I make the formula count all the females, and among them, those who live in CA for instance...???

 

[Yogi Anand]

Hi gymwrecker:

You can use the SUMPRODUCT function for this ... see the worksheet simulation

Book1
	F	G	H	I	J
1
2	Gender	State
3	M	MI
4	M	CA
5	F	CA		countof"F"from"CA"	2
6	M	MA
7	F	IL
8	F	CA
9	F	MI
10	M	CA
Sheet4

Regards!

Yogi

 

[gymwrecker]

Got it Yogi, Thanks!!!

 

[gymwrecker]

Yogi, how come it says "Board Master" right below my username?

 

[Yogi Anand]

Hi gymwrecker:

The Board considers you as a valued member of the community, and since you have a significant number of posts (I believe the reference number is 50), you have the title of Board Master ...

COGRATULATIONS

Regards!

Yogi
This message was edited by Yogi Anand on 2002-09-28 19:40

 

[gymwrecker]

Great! I didn't know that.... and yes, that's very true, I have been posting questions often.... Later Yogi!!!