Countif from a starting point using offset

Hi All,

in the attached spreadsheet, with the help of Glen Kennedy and Fluff13, in a previous thread, a 6 digit text string is split out into individual characters, one character per column. Thanks again.

In the data, where ever there is an "x", the values are summed only to the right of the columns where the "x" is. No Problem.

However, if in the columns to the right of the "x", there is a 0, I need to make an adjustment in the summation. Basically because 0 can actually mean a number anywhere between 10 & 24. 0 is not 0, in this case.

In column P, using Countif, I can determine how many 0's there are in the 6 digit string text. No Problem.

But what I really need to count is how many 0's are to the right of the "x". Anything to the left of the "x" is not considered.

Any ideas would be greatly appreciated.

None of the cells in C3:C17 have a 0 to the right of an x.

There's a note in cell O2 stating don't calculate if x appears as 5th or 6th character.

If you want the number of 0s to the right of x when x appears in columns 1 to 4, try

Formula:

Please Login or Register  to view this content.

where X99 is a placeholder for your actual cell addresses.

Hi hrlngrv. That is perfect. Thank you.

I'm not using the separate columns of individual letters. I don't see any pressing need for them. If cell X99 contained a string of up to 6 characters,

Formula:

Please Login or Register  to view this content.

where 0 would indicate either no x in X99, or nothing to the right of it (i.e, it's the last character).