Countif there is a match in 2 different places

[JakkeJakobsen]

I think the title says it all.

I have column A, and column AA. I want it to see if it finds anything from AA in A, and if it does, give me the count of how many.

Any help with that?

Thanks,
Jim

 

[JoeMo]

=COUNTIF(AA:AA,A1)

and copy down.

 

[JakkeJakobsen]

The AA:AA will search for a value in AA column, but will the A1 search through the whole of A column?

 

[JakkeJakobsen]

The AA:AA will search for a value in AA column, but will the A1 search through the whole of A column?

I can answer myself and say that no, it doesn't.

=COUNTIF(AA:AA,A1) will only search for a match between AA:AA and A1, not AA:AA and A:A, which is what I need. Search for matches between two ranges, and count them.

 

[JoeMo]

I can answer myself and say that no, it doesn't.

=COUNTIF(AA:AA,A1) will only search for a match between AA:AA and A1, not AA:AA and A:A, which is what I need. Search for matches between two ranges, and count them.

Maybe:

=SUMPRODUCT(COUNTIF(AA:AA,A:A))

 

[JakkeJakobsen]

Maybe:

=SUMPRODUCT(COUNTIF(AA:AA,A:A))

=SUMPRODUCT(COUNTIF($A$6:$A$18,$Y$2:$Y$41))

This worked for me. The AA moved to X:X, this is the column after it, obviously.