Results 1 to 4 of 4

Thread: Countifs with partial match

  1. #1
    Board Regular
    Join Date
    Nov 2014
    Posts
    163
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Countifs with partial match

    I need a countifs column that will count values in columns that contain the words TA2 and EFG. The column headings are something like "2019: Year 11 TA2 (22 Jan 2019): Mathematics: EFG"

    So I need to count any value where the column that contains the words TA2 and EFG and the student has a grade of 7 or above. I've tried using =COUNTIFS(SubHeads,"*TA2*"&"EFG",BN2:IS2,">=7") but come up with a #value .

    Thanks in advance.

    Fazila

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    49,667
    Post Thanks / Like
    Mentioned
    51 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Countifs with partial match

    With COUNTIFS, you can test multiple conditions. So break this part up into multiple conditions.
    First, check your range for the entry "*TA2*".
    Second, check the same range for entry "*EFG*"
    Third, check any other conditions (looks like you are looking for values greater than 7).
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular
    Join Date
    Nov 2014
    Posts
    163
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Countifs with partial match

    Thanks Joe4 worked great

  4. #4
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    49,667
    Post Thanks / Like
    Mentioned
    51 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Countifs with partial match

    You are welcome.
    Glad I was able to help!
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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