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/14 8/23/14 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 04, 2014.