Most valuable professional
  • Hot Topics

Excel Formula for Finding the Average Number of Calls per Month

Hello Everyone, I have a telephone record spreadsheet that I need to find the average number of calls per month and the average number of calls, per telephone number, each month. This spreadsheet consist of several telephone numbers and a range of dates. The dates are listed as follows: 8/22/2014 8/23/2014 all the way to.... 5/21/14 (in this format) The number format is: 000-000-0000 The range is: B6:B1560 What formula do I use to find out the number of calls each month? and The average number of calls, per telephone number, each month? Thank you so much for your help.

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of November 4, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel