+ Reply to Thread
Results 1 to 4 of 4

Countifs with text and date

  1. #1
    Registered User
    Join Date
    06-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    41

    Countifs with text and date

    Greetings,
    Racking head on this. I have a column with dates, and need to only count the ones that have text in another column. Please help!

    Col A - Name
    Col B - Section
    Col C - Training Date

    There are 5 different sections in Col B.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Countifs with text and date

    Not real clear so this is only a guess...

    =COUNTIFS(B2:B100,"*",C2:C100,"<>")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    06-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    41

    Re: Countifs with text and date

    THANK YOU! I was able to make it work by replacing the * with the section.

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Countifs with text and date

    Good deal. Thanks for the feedback!

+ 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. [SOLVED] COUNTIFS multiple criteria (date range & text)
    By jholiday78 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-30-2014, 06:36 PM
  2. Replies: 2
    Last Post: 05-28-2014, 06:52 AM
  3. CountIfs By Month - Multiple Date and Text Conditions
    By MAC0605 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-08-2013, 06:22 PM
  4. Replies: 0
    Last Post: 12-16-2011, 09:01 AM
  5. COUNTIFS Using Date Text as Variable
    By ltsolis in forum Excel General
    Replies: 3
    Last Post: 09-08-2011, 07:25 PM

Tags for this Thread

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