+ Reply to Thread
Results 1 to 4 of 4

Help with COUNTIF/ COUNTIFS

  1. 11-10-2015, 11:31 PM #1
    cjharwood
    cjharwood is offline
    Registered User
    Join Date
    07-21-2015
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    40

    Help with COUNTIF/ COUNTIFS

    Hi all,
    I've been pulling my hair out with something that I thought I knew and now I can't seem to figure out.

    I was to count all the entries in column A as long as they are classified as "Enrolled" in my service as indicated in column L.

    I have tried COUNTIF(A:A,L:L,"Enrolled") but this isn't working. Any suggestions?

    Thanks in advance!
    Reply With QuoteRegister To Reply
  2. 11-10-2015, 11:37 PM #2
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: Help with COUNTIF/ COUNTIFS

    Is there condition of column A?
    If not:
    =COUNTIF(L:L,"Enrolled")
    If column A not blank:
    =COUNTIFS(A:A,"<>"&" ",L:L,"Enrolled")
    Quang PT
    Reply With QuoteRegister To Reply
  3. 11-11-2015, 12:03 AM #3
    cjharwood
    cjharwood is offline
    Registered User
    Join Date
    07-21-2015
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Help with COUNTIF/ COUNTIFS

    Thanks heaps.. It's always the simple solutions that I seem to overlook!
    Reply With QuoteRegister To Reply
  4. 11-11-2015, 07:53 AM #4
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Help with COUNTIF/ COUNTIFS

    Quote Originally Posted by bebo021999 View Post
    If column A not blank:
    =COUNTIFS(A:A,"<>"&" ",L:L,"Enrolled")
    "<>"&" " means "not equal to space".

    If you want to test for "is not blank" use:

    =COUNTIFS(A:A,"<>",L:L,"Enrolled")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] % and COUNTIF/COUNTIFS
    By cjharwood in forum Excel General
    Replies: 3
    Last Post: 09-06-2015, 08:47 PM
  2. [SOLVED] Need help with =COUNTIF or =COUNTIFS
    By portokie in forum Excel General
    Replies: 3
    Last Post: 09-02-2015, 06:16 PM
  3. Need help with COUNTIF, COUNTIFS, or maybe something else
    By M_Easty in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2013, 03:21 PM
  4. Need Help with Countif or countifs
    By ihateexcelmorethanu in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-27-2013, 03:52 PM
  5. Countif and Countifs
    By alexfamily5 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-15-2013, 05:51 PM
  6. [SOLVED] How do I use countif or countifs, and how?
    By xodiak in forum Excel General
    Replies: 7
    Last Post: 06-01-2012, 11:10 AM
  7. Countif or countifs - please help
    By Davidcat in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-24-2011, 04:53 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1