Excel 2007 : How to count number of cells doubles?

**alpha45** · 07-06-2012, 05:43 AM

Hello and thank you for any help. I have a problem that I can not solve: imagine to have cells with numeric values to be compared cosiderazione picking them horizontally with the following items in sequence on the lines below: eg. R1: Z1; R1000: Z1000, I wish I was back in the row in question (eg, in the cell side), the number of rows with the same content of the 6 cell values and once you find these correspondences, were no longer taken into account. I hope I was clear and I enclose an example, I searched in the discussions, but I did not find specific posts. Thanks
immagine.jpg

**zbor** · 07-06-2012, 06:01 AM

Try: =COUNTIFS(A:A,A1,B:B,B1,C:C,C1)

change ; to , if you get error: =COUNTIFS(A:A;A1;B:B;B1;C:C;C1)

**alpha45** · 07-06-2012, 06:51 AM

Originally Posted by zbor

Try: =COUNTIFS(A:A,A1,B:B,B1,C:C,C1)

change ; to , if you get error: =COUNTIFS(A:A;A1;B:B;B1;C:C;C1)

Hello, thanks for the answer
This code should be placed as a function in Worksheet?
if I put a function =COUNTIFS(R:R;R1;S:S;S1;T:T;T1) Result: The formula contains unrecognized text: #NOME?

**Pepe Le Mokko** · 07-06-2012, 06:56 AM

Forse =SOMMA.PIÙ.SE(R:R;R1;S:S;S1;T:T;T1)

**alpha45** · 07-06-2012, 07:34 AM

I solved with this: creates a column of support as the "N" and N1-overs and drag: Codice:
=CONCATENA(J1;K1;L1)

In M1 overs and drag:

Codice:
=SE(CONTA.SE($N$1:N1;N1)>1;"";CONTA.SE($N$1:$N$1000;N1))

If the numbers do not repeat do not want them counted, with this change in M1:
Codice:
=SE(O(CONTA.SE($N$1:N1;N1)>1;CONTA.SE($N$1:$N$1000;N1)=1);"";CONTA.SE($N$1:$N$1000;N1))
Grazie