Results 1 to 3 of 3

Thread: COUNTIF (2002)

  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Reading, Berkshire, England
    Posts
    199
    Thanks
    9
    Thanked 0 Times in 0 Posts

    COUNTIF (2002)

    I have a class rota with certain periods containing the letter W or T denoting specific subjects. I want to count these periods in the day. The following works fine =COUNTIF(cell range,"=W ")returning me the number of periods with the subject "W".
    The following will not return anything, =COUNTIF(cell range,("=W")*OR("=T")) when I have the subjects "W" or "T" in the day, Why. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
    I want it to Count the periods with abbreviation "W" OR "T" in the day.

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

    Re: COUNTIF (2002)

    Why? Because COUNTIF doesn't work that way. You can't specify multiple conditions. Try

    =COUNTIF(cell range,"=T ")+COUNTIF(cell range,"=W ")

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Reading, Berkshire, England
    Posts
    199
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: COUNTIF (2002)

    Thanx Hans the following works fine =COUNTIF(B7:M7,"T")+COUNTIF(B7:M7,"W"). Note I don't need the = sign <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

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