Countif (multiple conditions)

gymwrecker

Active Member
Joined
Apr 24, 2002
Messages
347
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

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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

Active Member
Joined
Apr 24, 2002
Messages
347
Great! I didn't know that.... and yes, that's very true, I have been posting questions often.... Later Yogi!!!
 

Forum statistics

Threads
1,144,312
Messages
5,723,650
Members
422,508
Latest member
Lordkit1

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top