+ Reply to Thread
Results 1 to 10 of 10

countif - specific criteria

  1. #1
    Registered User
    Join Date
    11-29-2012
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    32

    countif - specific criteria

    Hi,

    I'm trying to colleate several spreadsheets by highlighting key information. We run several courses and it would be nice to have 1 central sheet where we can check number of delegates per course.

    At the moment i'm using countif formulas on each register, to count the names of delegates, and also count schools.
    We have 1 course that has 3 seperate parts (A,B and C)
    Is there a formula to count say- if Cell D4 contains A, then count C4 (name of delegate) if D4 does not contain A, do not count.

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: countif - specific criteria

    Hi,

    Yes, you can use COUNTIFS() instead of COUNTIF().

  3. #3
    Registered User
    Join Date
    11-29-2012
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: countif - specific criteria

    Would you be able to give me an example?

    Basically my spreadsheet has the name of school in Column B, Name of 1st delegate in C and D is either session A,B or C

    I've tried =COUNTIFS(C4:C22,D4="A") but the value returns as 0 despite an A being in column D

  4. #4
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: countif - specific criteria

    Hi,

    Can you post a sample template of your workbook please?

  5. #5
    Forum Contributor
    Join Date
    07-13-2015
    Location
    Poland
    MS-Off Ver
    MS Office 365
    Posts
    171

    Re: countif - specific criteria

    you're searching course A within column with courses type, not names, so i think you shoul use:
    Please Login or Register  to view this content.
    but intead of "A" you can insert cell adress where course type is defined
    Last edited by zico8; 07-13-2015 at 05:18 PM.

  6. #6
    Registered User
    Join Date
    11-29-2012
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: countif - specific criteria

    Register -TEMPLATE.xlsx

    There is an example of the register I am using. I want to be able to count how many people are attending session A, B and C so I can link the figure to another spreadsheet so the teachers can quickly see, at a glance, how many delegates they will have for each session.

    I tried =COUNTIF(D4:D22,"A") but it wouldn't count the cells that had more than just A

  7. #7
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: countif - specific criteria

    Try the following instead:

    =COUNTIF(D4:D22,"*"&"A"&"*")

  8. #8
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: countif - specific criteria

    put * around the A

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    attached sheet with a cell reference method as well
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  9. #9
    Registered User
    Join Date
    11-29-2012
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: countif - specific criteria

    This is perfect - explains exactly what I need and how the formula works. Thank you all

  10. #10
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: countif - specific criteria

    You are welcome

    You can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 05-14-2015, 02:48 PM
  2. [SOLVED] COUNTIF visible cells matching specific criteria
    By MP1989 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-17-2015, 06:07 PM
  3. Return dates that match a single criteria (a countif criteria)
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-07-2014, 12:43 PM
  4. Need help with COUNTIF function - with specific criteria search
    By robbertl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-20-2012, 12:19 PM
  5. Countif w/ Multiple Criteria-How do I use countif
    By Patrick_KC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2005, 05:05 PM
  6. [SOLVED] Countif using format criteria not number criteria?
    By Rumbla76 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-20-2005, 01:06 AM
  7. [SOLVED] Countif using format criteria....not number criteria?
    By Troy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-20-2005, 12:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1