Hi,
I'm working with binary code on the left side from P:AN, and on the right, I'm looking for a formula that will be able to count the (1) as long as they are not separated by a (0).So for example the first row P9:AN9.The formula will start in cell AQ9 and drag to the right, is that possible ...