Maybe this...

Array entered:

=SUM(IF(FREQUENCY(IF(ISNUMBER(B1:Z1),COLUMN(B1:Z1) ),IF(NOT(ISNUMBER(B1:Z1)),COLUMN(B1:Z1)))6,1))

--
Biff
Microsoft Excel MVP


"lopina" wrote in message
...
Hello

one more question, is it posiblle:


If cell=IS then is empty cell.

If I have

3 3...1 1 2 2 3 3...1 1 1 IS 1 1 1 ...2 2 2 2 2 ...

Then result for this formula is 0.

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



best regards
Ivo


"T. Valko" wrote in message
...
You're welcome!

--
Biff
Microsoft Excel MVP


"lopina" wrote in message
...
Hello

this is excelent, You sve me lot of work.

best regards
Ivo



"T. Valko" wrote in message
...
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