# Thread: Totaling a Column of X's (Excel 2000)

1. ## Totaling a Column of X's (Excel 2000)

I have a column.....some lines are X'd some are not. At the end I want the count how many X's. Is there a formula I can use?

Also I have a column......in that column are some lines with DP, some lines with WSJ, some lines with RMN. At the end of that column I want to tally how many of each code. Is there a formula for that?

Thanks so much, :-)

2. ## Re: Totaling a Column of X's (Excel 2000)

Assuming the column of data is in A1:A100 (change as appropriate)
Something like:
=Countif(A1:A100,"X")

For the others something like: (if they "contain" the text):
=COUNTIF(A1:A100,"=*DP*")
=COUNTIF(A1:A100,"=*WSJ*")
=COUNTIF(A1:A100,"=*RMN*")

Steve

3. ## Re: Totaling a Column of X's (Excel 2000)

THANKS!

One more problem I realized I'm having. What if I want to count the X's with DP only?...or the X's with RMN only?

4. ## Re: Totaling a Column of X's (Excel 2000)

I would create a pivot table based on your data. Add the field (column) with the X to the Row area, the field with the DP, RMN etc. to the Column area, and a column that contains no blank cells to the Data area. If necessary, select Count as summary function for this field.

5. ## Re: Totaling a Column of X's (Excel 2000)

If the "X" is in A1:a100, and the "DP" is in B1:B100, then the following formula will count the number of rows with "X" in column A and "DP" in column B:

<pre>=SUMPRODUCT(1*(A1:A100="X"),1*(B1:B100="DP" ))
</pre>

#### Posting Permissions

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