How to count two cells occurrences in a worksheet
 

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

How to count two cells occurrences in a worksheet
 

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?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

<ben mustapha wrote in message ...
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

How to count two cells occurrences in a worksheet
 

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...

"ben mustapha" wrote:

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

How to count two cells occurrences in a worksheet
 

Hi,

Here's what you want:

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

--
Thanks,
Shane Devenshire


"ben mustapha" wrote:

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