How to count two cells occurrences in a worksheet

[ben mustapha]

Dear Expert,
I have a excel worksheet of 5 column and 100 rows with random cells values, I would like to count the occurrence of two cells in the worksheet. For example, if A1=1, A2=3 and C5=1 and C6=3 then the occurrence number is 2, and so on...

Thanks

 

[Bernard Liengme]

Do you wish to count how many times two adjacent cells hold the same
numbers? Is this any pairs of numbers or 1 and 3 specifically? Does (1, 3)
match (3, 1) or is the order important?

 

[Sheeloo]

Need more information...

Do you want to count the occurences of each number in the worksheet?
=Countif(A1:E100,1) will give you the count of times 1 occurs in first five
columns and 100 rows...

 

[ShaneDevenshire]

Hi,

Here's what you want:

=SUMPRODUCT(--(COUNTIF(A1:E100,A1:E100)=2))