Countif (multiple conditions)

gymwrecker

Active Member
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...???

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Hi gymwrecker:

You can use the SUMPRODUCT function for this ... see the worksheet simulation
Book1
FGHIJ
1
2GenderState
3MMI
4MCA
5FCAcountof"F"from"CA"2
6MMA
7FIL
8FCA
9FMI
10MCA
Sheet4

Regards!

Yogi

Got it Yogi, Thanks!!!

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

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

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

Replies
1
Views
288
Replies
1
Views
162
Replies
19
Views
521
Replies
10
Views
390
Replies
4
Views
377

1,221,215
Messages
6,158,580
Members
451,501
Latest member
andysacko

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back