+ Reply to Thread
Results 1 to 4 of 4

Count of Name in Excel With Respect of Date Range

  1. #1
    Registered User
    Join Date
    01-26-2018
    Location
    Pakistan
    MS-Off Ver
    2016
    Posts
    2

    Post Count of Name in Excel With Respect of Date Range

    Hi Friends, Need some help as i got stuck in this. i have a sheet where "Nasir" could have multiple entries and other team as well. i want to count the number of entries of each member date wise as i have the count but i could be able to get the date values automated, this hard coded is ok and working. I know, something i missed.

    =COUNTIFS(A2:A2322, "=2-Jun-2017", C2:C2322,"=Nasir")

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,077

    Re: Count of Name in Excel With Respect of Date Range

    Does this work?

    =COUNTIFS(A2:A2322, DATEVALUE("02-Jun-2017"),C2:C2322,"Nasir")
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    01-26-2018
    Location
    Pakistan
    MS-Off Ver
    2016
    Posts
    2

    Re: Count of Name in Excel With Respect of Date Range

    Thanks for sharing the same. However i tried the same and count is coming but what i want is to pick the "DATEVALUE("02-Jun-2017")" automatically from a column and match the previous date range. Please see if you could help me in this.

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,077

    Re: Count of Name in Excel With Respect of Date Range

    Post an example file, desensitise if it necessary.

+ 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. Find occurance with respect to count
    By puttu in forum Excel General
    Replies: 2
    Last Post: 11-19-2013, 02:01 PM
  2. [SOLVED] Help! How do I get excel to count data within a date range?
    By RandomGuy2 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-12-2013, 10:56 AM
  3. Replies: 4
    Last Post: 01-17-2013, 01:23 PM
  4. [SOLVED] How to count Unique Number with respect to Date
    By amit.nikhil in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-29-2012, 02:17 AM
  5. [SOLVED] Excel 2007 : sum between two date with respect to specific customer
    By shaileshgavanang in forum Excel General
    Replies: 4
    Last Post: 06-15-2012, 02:45 PM
  6. Can I get excel to count a date range? but slightly more complicated
    By daybreak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-07-2011, 04:30 PM
  7. 3 columns; date and two data, problem is sorting and calculating with respect to date
    By phosphorescence in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2008, 04:21 PM
  8. [SOLVED] How do I count items within a date range in Excel?
    By tcolbert in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2006, 02:10 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