Countif formula

[baggarwal]

Hi All:

Can you please tell me how i can do a countif based on multiple conditions. Here is an example data set.

F E
R F
F F
R E
R F

Lets say I need a formula that will look for a match in column A for R and the another match in column of F. Then I want to count the number of times this match occurs. In this set it would be 2. Can someone please explain how I can do this through a formula.

 

[Jonmo1]

Try

=SUMPRODUCT(--(A1:A10="R"),--(B1:B10="F"))

Hope that helps.

 

[markmzz]

Or try this formula (array formula - use Ctrl+Shift+Enter and not only Enter):

=SUM(IF($A$1:$A$5="R",IF($B$1:$B$5="F",1,0),0))

Markmzz

 

[T. Valko]

Hi All:

Can you please tell me how i can do a countif based on multiple conditions. Here is an example data set.

F E
R F
F F
R E
R F

Lets say I need a formula that will look for a match in column A for R and the another match in column of F. Then I want to count the number of times this match occurs. In this set it would be 2. Can someone please explain how I can do this through a formula.

If you're using Excel 2007 or later...

=COUNTIFS(A1:A5,"R",B1:B5,"F")