Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    May 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #3
    New Lounger
    Join Date
    May 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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>

    Legare Coleman

Posting Permissions

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