Calculating no. of calls per person per month

Hi All,

 

I’d appreciate your help on the below:

 

Outline:

       3 people (Amy, Harry, Sophie)

       Various dates of calls made (Dates in this format: “DD/MM/YYYY”)

 

Question:

 1. How to calculate calls made per person (eg. Amy only) per Month?

 

(I tried COUNTIF but it doesn’t work in this case because it calculates the chosen word all across the column, not just eg. In January like I would like to see)

 2. How to create a chart to see number of calls per each month per each person? (all these stats per each person on one chart)

 

 

Name

Date of call

Amy

09/01/2018

Harry

17/02/2018

Harry

11/03/2018

Amy

22/03/2018

Harry

30/03/2018

Sophie

03/04/2018

Sophie

04/04/2018

Harry

10/05/2018

Sophie

22/05/2018

Harry

20/06/2018

 Thank you

 

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:””;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:”Calibri”,sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}

Emma

By: Patricia

Leave a Reply

Your email address will not be published. Required fields are marked *