1. Registered User
Join Date
Oct 2003
Posts
3

I need to know if there is a formula that will help me on this.
I have a workbook like below:
A B C D E
1. DATE CLAIM# ONGOING TCM
2 11/01 346748 X JONES
3 11/01 786345 JONES
411/01 75845 X JONES
511/01 67345 JONES
611/01 678934 X JONES

What I need to do is count all instances of the name(D) and within that,
how many "X's" are tide to that name. Is there a way to do this? There are about 20 different names and the sheet runs about 3000 rows. Any help, is greatly appreciated. Thank You.

2. Registered User
Join Date
Jul 2003
Location
Earth | North America | United States | California | Long Beach
Posts
62
A quick and dirty way of doing it would be to use filters and subtotals.

How will you use the resulting information?

Jack

3. Registered User
Join Date
Oct 2003
Posts
3
[QUOTE][SIZE=1]Originally posted by Jaash
A quick and dirty way of doing it would be to use filters and subtotals.

How will you use the resulting information?

Jack [for month end reports and I do not wish to use filters. Must be a formula to do this, but thanks.SIZE]

4. Registered User
Join Date
Oct 2003
Posts
61
is the "x' always in the same column as the Name ?? and is there always one x or can there be mor then one x?

5. Registered User
Join Date
Oct 2003
Posts
3
The "X" is always in colume "c" and only 1 x per row. Where there will be about 20 different names, and not always an "X" in colume "C", I would like a formula to count every instance of the name for total claims per name, and the "X" associated with the name, for ongoing total. Thank you

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•