Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Toronto, Canada, Ontario
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help Counting Text (Excel 2002/WXP)

    I first have to say that I do not use Excel often, and so am not as adept as i am, say, with Word. Even so, I know this is a basic question. I have a chart with, say 10 columns. One column, call it Term, has entries that are either F, W or Y. I need a formula that will tell me how many of each of those values are in the column. I've mucked about with COUNTA and DCOUNTA, but never seem able to put in values that work.

    If anyone would be kind enough to give me a template, I'd be grateful

    TIA, Michael

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help Counting Text (Excel 2002/WXP)

    You can use COUNTIF for this. Say that your data are in A1:A40, then =COUNTIF($A$1:$A$40,"F") will count the number of F's. See attached workbook for a variation that uses a named range.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Toronto, Canada, Ontario
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help Counting Text (Excel 2002/WXP)

    Many Thanks - works fine!!

Posting Permissions

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