Results 1 to 5 of 5

Thread: Counting Names in one column, only IF there is a date entered into another column
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Counting Names in one column, only IF there is a date entered into another column

    Hi Guys,

    Just joined the forum so I could post a question as I've searched for an answer to this on the net and couldn't find it.

    I have a spreadsheet with employee names (Advisors) in one column (H) and when the advisor generates a new client application we put the application date in another column (T).

    What I need to be able to do is count the number of applications each advisor has (broken down into each month) and keep count as dates are added.

    If tried CountIFS and read some solutions with SUMPRODUCT but not managed to adapt it for my needs and kept getting errors, I know some of the basics with excel but am a bit of a novice (especially compared to you guys).

    Any help greatly appreciated.

    Thanks


  2. #2
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,976
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    21 Thread(s)

    Default Re: Counting Names in one column, only IF there is a date entered into another column

    Welcome to the MrExcel board!

    Would Excel's Pivot Table feature be sufficient?
    Assuming the columns between H & T also have data you can create it directly as shown below. If blank columns between then post back for a work-around if you think this might be useful.

    Sheet1

    HTUVWXYZ
    1AdvisorApplication Date Count of Application DateMonth
    2Advisor 71/01/2019 JanFebMarGrand Total
    3Advisor 65/01/2019 Row Labels
    4Advisor 725/01/2019 Advisor 213 4
    5Advisor 225/01/2019 Advisor 4 1 1
    6Advisor 531/01/2019 Advisor 51 12
    7Advisor 22/02/2019 Advisor 611 2
    8Advisor 63/02/2019 Advisor 721 3
    9Advisor 220/02/2019 Grand Total56112
    10Advisor 221/02/2019
    11Advisor 722/02/2019
    12Advisor 423/02/2019
    13Advisor 55/03/2019
    14


    Excel tables to the web >> Excel Jeanie HTML 4
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  3. #3
    New Member
    Join Date
    Aug 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Counting Names in one column, only IF there is a date entered into another column

    Hi Peter,

    Thanks for the reply, yes it might do the trick, mine doesnt display as yours in the picture but it does give me the data so that's great.

    I'm struggling to get it to display by month though so i've inserted a timeline, that doesn't show all the months side by side though. Propably just need to hit a button somewhere.

    Thanks so much.

  4. #4
    New Member
    Join Date
    Aug 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Counting Names in one column, only IF there is a date entered into another column

    I've managed to hget it into Months, that's great thanks.

  5. #5
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,976
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    21 Thread(s)

    Default Re: Counting Names in one column, only IF there is a date entered into another column

    Quote Originally Posted by Yorkshire Man View Post
    I've managed to hget it into Months, that's great thanks.
    God news. Thanks for letting us know.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the # key in the Reply window
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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