Good Evening,

Need a bit of help.

I am trying to count the time a number "1" or "0" are contained in a row.
To make it a bit more complicated (at least for me) each cell contains 3
characters "HE1" or "HE0" the Alpha characters are non players and may or
may not be "HE" at this point I need to find the number of "1's" that are in
a Row, the # is always the last character as the above Sample. I would like
to count the "1's" in say cell FD1 and and the zeros "FE1". I have
approximately 160 cells in a row of cells there are approximately 300 rows.

I have a method but it is sure sloppy.

Thanks in advance.
cil

On Feb 9, 4:06*pm, "cil" <eat_p...@bacon.com> wrote:
> I am trying to count the time a number "1" or "0" are
> contained in a row.
[....]
> the # is always the last character as the above Sample.

Not sure I understand. Does the following work for you?

=SUMPRODUCT(--(RIGHT(A1:Z1,1)="1"))

If not, why not? That is, provide some counter-examples.

Thanks for the quick response.

I have similar to this example:
he1 he1 hw1 qw0 qw1 he0

How many "1s" and "0's" will be at the end of the row. there are ~160 cells
in a row with this type of info.

Thanks again.
cil

"joeu2004" wrote in message
news:7f609fcf-c458-4cac-978a-(E-Mail Removed)...

On Feb 9, 4:06 pm, "cil" <eat_p...@bacon.com> wrote:
> I am trying to count the time a number "1" or "0" are
> contained in a row.
[....]
> the # is always the last character as the above Sample.

Not sure I understand. Does the following work for you?

=SUMPRODUCT(--(RIGHT(A1:Z1,1)="1"))

If not, why not? That is, provide some counter-examples.

joeu2004,

the formula you sent works. THANK YOU!!



"joeu2004" wrote in message
news:7f609fcf-c458-4cac-978a-(E-Mail Removed)...

On Feb 9, 4:06 pm, "cil" <eat_p...@bacon.com> wrote:
> I am trying to count the time a number "1" or "0" are
> contained in a row.
[....]
> the # is always the last character as the above Sample.

Not sure I understand. Does the following work for you?

=SUMPRODUCT(--(RIGHT(A1:Z1,1)="1"))

If not, why not? That is, provide some counter-examples.