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