+ Reply to Thread
Results 1 to 2 of 2

Countifs cell has date within month AND other cell on row is eual to specific criteria.

  1. #1
    Registered User
    Join Date
    09-18-2013
    Location
    USA
    MS-Off Ver
    2010
    Posts
    29

    Countifs cell has date within month AND other cell on row is eual to specific criteria.

    I need to count the number of cells in a column with a date that falls in a specific month, but the cell in another column on the same row must equal something specific as well.
    More specifically, I need to count the number of dates that fall within the month for each specific group.
    The date column is formatted as 'm/d/yy h:mm AM/PM'. I do not care about the time, only the date, but do not want to have to modify that if possible.
    I need to make sure that blank cells are not counted at all.

    I have attached a sample. The actual file is much larger. I would like the count to appear in column F.
    If correct, cell F2 would display the number 2, because only two users in Group 1 have a date listed.

    Thanks for your help! I am getting an error when trying to attache the file, here are the details.

    User Date User Group User Group Number of user with date within month on group
    1 1/2/15 9:55 AM 1 1
    2 1 2
    3 1 3
    4 1 4
    5 1 5
    6 10/29/14 2:36 PM 1 6
    7 1
    8 1
    9 1/5/15 10:10 AM 1
    10 1/2/15 9:55 AM 2
    11 2
    12 2
    13 2
    14 2
    15 10/29/14 2:36 PM 2
    16 2
    17 3
    18 1/5/15 10:10 AM 3
    19 1/2/15 9:55 AM 3
    20 3
    21 3
    22 3
    23 4
    24 10/29/14 2:36 PM 4
    25 4
    26 4
    27 1/5/15 10:10 AM 4
    28 1/2/15 9:55 AM 5
    29 5
    30 5
    31 5
    32 5
    33 10/29/14 2:36 PM 5
    34 5
    35 5
    36 1/5/15 10:10 AM 5
    37 1/2/15 9:55 AM 6
    38 6
    39 6
    40 6
    41 6
    42 10/29/14 2:36 PM 6

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Countifs cell has date within month AND other cell on row is eual to specific criteria

    Please attach a copy of your workbook so we don't need to recreate your data to find a solution. Remember to remove/replace any sensitive info before uploading.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ 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. Update date Specific cell by use Specific Month
    By Nisar.mohammed in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2014, 11:26 AM
  2. COUNTIFS to recognize MONTH in a cell
    By mmsteiner in forum Excel General
    Replies: 6
    Last Post: 12-04-2014, 04:13 PM
  3. [SOLVED] Remove specific text from a cell and than sort cells by month and date
    By Boo123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2014, 05:05 PM
  4. Replies: 2
    Last Post: 09-10-2012, 04:16 AM
  5. Month Criteria in Countifs ????
    By mubashir aziz in forum Excel General
    Replies: 4
    Last Post: 02-26-2010, 05:38 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