Countif - Counting where cells are equal?

[Smokeyham]

I thought this would be simple, but I seem to be missing something.

I want to count the number times the value in the cell in column R matches the same value of a cell in the same row in column A.

For instance

A1 = R1
A5 = R5
A93 = R93

Then the total will be three.

I've been trying to use the CountIf function - but is there another way to do this?

Thanks.....

 

[AhoyNC]

Try:

=SUMPRODUCT(--(A1:A93=R1:R93))

or if you don't want to include blank cells:

=SUMPRODUCT(--(A1:A100=R1:R100),--(A1:A100<>""))

 

[Smokeyham]

AhoyNC,

Thanks so much! Just what I needed!

Gordo

Try:

=SUMPRODUCT(--(A1:A93=R1:R93))

or if you don't want to include blank cells:

=SUMPRODUCT(--(A1:A100=R1:R100),--(A1:A100<>""))

 

[AhoyNC]

You're welcome. Thanks for the feedback.