Ok, you could use the formulas for your other question then just count how
many are 6:

=COUNTIF(B2:Z2,"6")

Or, you can use this array formula** :

=SUM(IF(FREQUENCY(IF(B1:Z1<"",COLUMN(B1:Z1)),IF(B 1:Z1="",COLUMN(B1:Z1)))6,1))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"lopina" wrote in message
...
Yes the result would be 1.

You are right

best regards
Ivo



"T. Valko" wrote in message
...
I'm not sure I understand.

sheet1
3 3...1 1 2 2 3 3...1 1 1 1 1 1 1...2 2 2 2 2 2

You want to count how many consecutive "runs" there are that are 6? So,
in the above sample the result would be 1?

--
Biff
Microsoft Excel MVP


"lopina" wrote in message
...
I have one more question.


sheet1
3 3 1 1 2 2 3 3 1 1 1 1 1 1 1 2 2 2 2 2 2


sheet2
A1=7


Let say I have theese thata in sheet1, on sheet2 in cell A1 I need
counting only line of numbers that is bigger then 6 in a row in thesse
range on sheet1.
Is it possibly I can not figure out.

best regards
Ivo

"T. Valko" wrote in message
...
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"lopina" wrote in message
...
It is working.

Thanks You are great,

best regards
Ivo



"T. Valko" wrote in message
...
Try this...

There *must* be an empty cell at the end of the range.

Let's assume the range of data is B1:Z1. Cell AA1 *must* be an empty
cell.

Enter this formula in B2:

=IF(B1="","",IF(AND(B1<"",C1=""),1,""))

Enter this formula in C2 an copy across to Z2:

=IF(C1="","",IF(AND(C1<"",D1=""),COUNTA($B1:C1)-SUM($B2:B2),""))

--
Biff
Microsoft Excel MVP


"lopina" wrote in message
...
Hello to all!!

I have one question if anybody can help me, in range I have to
calculate how many filled cell is they are one ater the oher.

Example:
A AE
3 3 1 1 2 2 3 3 1 1 1 1 1 1 1 2 2 2 2 2 2


Result if possible:

2filled 6filled 7filled 6filled

If somebody understand what I meen don't fear to help.

Thanks
Best regards
Ivo