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

Yorkshire Man

New Member
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


<colgroup><col span="5"></colgroup><tbody>
</tbody>
 

Peter_SSs

MrExcel MVP, Moderator
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.

Excel Workbook
HTUVWXYZ
1AdvisorApplication DateCount of Application DateMonth
2Advisor 71/01/2019JanFebMarGrand Total
3Advisor 65/01/2019Row Labels
4Advisor 725/01/2019Advisor 2134
5Advisor 225/01/2019Advisor 411
6Advisor 531/01/2019Advisor 5112
7Advisor 22/02/2019Advisor 6112
8Advisor 63/02/2019Advisor 7213
9Advisor 220/02/2019Grand Total56112
10Advisor 221/02/2019
11Advisor 722/02/2019
12Advisor 423/02/2019
13Advisor 55/03/2019
14
Sheet1
 

Yorkshire Man

New Member
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.
 

Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
Top