Counting assistance

[cil]

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

 

[joeu2004]

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.

 

[cil]

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

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.

 

[cil]

joeu2004,

the formula you sent works. THANK YOU!!



"joeu2004" wrote in message

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.