multi cell count in order ?

[JMITCH26]

How can I count cells A1:G1 and if it matches the criteria in the correct order then count and put the count number in cell B12.

Then look at cells A2:G2 and if it matches the criteria in the correct order then count and put the count number in cell B13 and so on


Example:

Cell
... A B D E F G
1 . 3 2 4 1 4 1
2 . 2 3 2 3 3 2
3 . 5 0 4 1 3 2
4 . 2 3 2 3 2 3
5 . 5 0 4 1 3 2
6 . 5 0 4 1 3 2
7 . 4 1 3 2 3 2
8 . 3 2 4 1 4 1


Cell
A12 ....... B12
Number Counts
324141 ... 2
504132 ... 3
232332 ... 1
232323 ... 1
413232 ... 1
414141 ... 0

 

[Peter_SSs]

Never mind, I have answered my own question. I will consider an answer.

 

[footoo]

What happened to column C ?

In H1 put this formula and fill down : =A1&B1&D1&E1&F1&G1

In B13 put this formula and fill down : =COUNTIF(H$2:H$8,A13)

 

[Peter_SSs]

You could count them directly like this. If column C is actually skipped, just change the ranges in the formula to suit.

Book1
	A	B	C	D	E	F
1	3	2	4	1	4	1
2	2	3	2	3	3	2
3	5	0	4	1	3	2
4	2	3	2	3	2	3
5	5	0	4	1	3	2
6	5	0	4	1	3	2
7	4	1	3	2	3	2
8	3	2	4	1	4	1
9
10
11	Number	Counts
12	324141	2
13	504132	3
14	232332	1
15	232323	1
16	413232	1
17	414141	0
Count

Cell Formulas
Range	Formula
B12	=SUMPRODUCT(--(A$1:A$8&B$1:B$8&C$1:C$8&D$1:D$8&E$1:E$8&F$1:F$8=A12&""))

 

[JMITCH26]

sorry my mistake it should have been B1:G1 so cells B1 C1 D1 E1 F1 G1

 

[JMITCH26]

Thank you that works awsome.

 

[Peter_SSs]

Thank you that works awsome.

Thanks for letting us know.