COUNTIF with an AND

[bbbb1234]

Data set
Col A
A
A
C
Col B
J
K
J

I want a function that will do this:=COUNTIF(A1:B3,AND(A1:A3="A",B1:B3="J")) and in the data set above, the COUNTIF would return 1.

I know that I could add a "Helper" column in Col C that has =AND(A1="A",B1="J") and put a =COUNTIF(C1:C3,TRUE") but I don't want to use a helper column.

Any ideas?

 

[kweaver]

I think you only need SUMPRODUCT: =SUMPRODUCT((A1:A3="A")*(B1:B3="J"))

 

[bbbb1234]

I think you only need SUMPRODUCT: =SUMPRODUCT((A1:A3="A")*(B1:B3="J"))

Worked perfect!!! Didn't think of that!!! Thanks a million!!!

 

[Eric W]

Also:

=COUNTIFS(A1:A3,"A",B1:B3,"J")

 

[bbbb1234]

Also:

=COUNTIFS(A1:A3,"A",B1:B3,"J")

This one also work perfect!! Thanks!!!!!