PC Review


Reply
Thread Tools Rate Thread

Counting assistance

 
 
cil
Guest
Posts: n/a
 
      10th Feb 2011
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

 
Reply With Quote
 
 
 
 
joeu2004
Guest
Posts: n/a
 
      10th Feb 2011
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.
 
Reply With Quote
 
cil
Guest
Posts: n/a
 
      10th Feb 2011
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.

 
Reply With Quote
 
cil
Guest
Posts: n/a
 
      10th Feb 2011
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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
counting function but not double counting duplicates =?Utf-8?B?SlJE?= Microsoft Excel Worksheet Functions 2 7th Nov 2007 06:43 PM
Remote assistance, assistance....aol related GotBonus Windows XP General 5 7th Jul 2006 09:21 PM
Remote Assistance - Offer Assistance =?Utf-8?B?d29ya2luZ3Rocm91Z2h4cA==?= Windows XP General 4 30th Apr 2006 03:50 AM
Counting Rows Then Counting Values in Columns Michael via OfficeKB.com Microsoft Excel Programming 1 1st Jun 2005 04:10 PM
Assistance with counting cells with numbers Neil Grantham Microsoft Excel Worksheet Functions 2 3rd Oct 2003 03:17 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:06 PM.