Countif (multiple conditions)

gymwrecker

Active Member
Joined
Apr 24, 2002
Messages
354
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

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
 

gymwrecker

Active Member
Joined
Apr 24, 2002
Messages
354
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Yogi, how come it says "Board Master" right below my username?
 

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
354
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Great! I didn't know that.... and yes, that's very true, I have been posting questions often.... Later Yogi!!!
 

Forum statistics

Threads
1,181,582
Messages
5,930,734
Members
436,757
Latest member
Marijn

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